How to import a Shapefile into Power BI?
1 MIN INTERMEDIATE IMPORT A SHAPEFILE, MICROSOFT 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.
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.
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!