I am using Microsoft Power BI Desktop. Can I import your maps (polygons) in a Power BI data sheet?

I am using Microsoft Power BI Desktop. Can I import your maps (polygons) in a Power BI data sheet?


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.

Import a Shapefile into Power BI

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.

Import a Shapefile into Power BI

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.

Import a Shapefile into Power BI

Congratulations! Now your map is successfully imported in Power BI!

Import a Shapefile into 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.