I am using Microsoft Power BI Desktop. Can I import your maps (polygons) in a Power BI data sheet?
access_time 4 MIN | fiber_manual_record INTERMEDIATE | label IMPORT DATA, MICROSOFT POWER BI, IMPORT TOPOJSON
Yes, it is definitely possible to import our geographical data (polygons) in Power BI. The only problem is that Power BI support TOPOJSON. Spotzi supports exporting to geoJSON, but not TOPOJSON. In order to do this, you need to do the following:
After you bought your map in the datashop, you have to export this data to a shapefile format. In this example, we use a sample of the 2-digit zip codes of the Netherlands and we export this data to a zipped shapefile.
After you have downloaded the shapefile, you have to go to Mapshaper.org. Here you can upload (drag and drop/select) the data and press import. Now you can see the boundaries of the 2-digit zip code sample of the Netherlands. Press export, select the TOPOJSON format and download the .json file.
Now it is time to upload your TOPOJSON in Power BI. First, you need to change the settings of the Power BI program to allow the “Shape Map” functionality. To do this go to:
File > Options and Settings > Options > Preview Features > Select the “Shape Map” checkbox.
After checking the checkbox, restart the Power BI program to make sure that the settings are executed.
Now you can access the “Shape Map” functionality in Power BI. After inserting this, you see a default map. To upload the TOPOJSON, press GET DATA, select JSON and upload the TOPOJSON file. Once uploaded, press +ADD MAP (under the SHAPE header) and here you can add the TOPOJSON file.
Congratulations! Now your map is successfully imported in Power BI!
Database with 100+ Shapefiles and geoJSON Files
Spotzi has a large Datashop with a lot of Shapefile (.shp) and geoJSON (.geojson) datasets with demographics, consumer spending, ZIP code boundaries, real estate data, addresses, business listings and many more. Our Datashop offers a one-stop-shop solution where you can browse through all our datasets and order them directly from our shop.