Help - Import into Microsoft Power BI Desktop


Import a Shapefile into Power BI?

Spotzi offers a very easy to use Mapping Tool (Spotzi Location) that can handle Shapefiles files. You can import Shapefiles you exported from Power BI and you can export KML files from our Location Plan into Power BI.

Contact Sales for our Location Plan

The only problem is that Power BI only supports TOPOJSON. Spotzi supports exporting to geoJSON, but not TOPOJSON. In order to do this, you need to do the following:

You have to export your 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

Related blog posts

Interested in our solutions? Please contact our sales team.

Whether you are new to data analytics or already an expert. We offer solutions for everyone. You don’t need to be a data expert to work with Spotzi Location. For more tailor made solutions we offer Spotzi Studio. With this plan you cannot only manage the data yourself but also connect to our API and manage users for the dashboards you create. Or work with our Market Ready Dashboards and drive on autopilot.