I'm trying to export a shapefile I've been using in QGIS for use in PowerBI because PowerBI only supports .JSON extensions. So I've been converting them with mapshaper.org. This is my shapefile result in PowerBI:


I've tried a couple of things:

  • Exported my "custom" .SHP file as a .GeoJSON (I say custom because I deleted the geographies I did not need in QGIS Attributetable - maybe this is causing the problem?). I then converted it in mapshaper.org to .JSON. The shape appears fine in the mapshaper.org preview, but it's wonky when I upload it to PowerBI as per my attached image above.
  • Converted the original shapefile I downloaded from StatsCan. This has all geographies (most of which I don't use). When I load this into PowerBI nothing happens. It basically hangs the program. The file is roughly 92MB. Again, when I'm converting use mapshaper.org the map appears correct.

I know this a GIS forum and not PowerBI so I don't expect help on that end.


The problem was with the CRS. Solution here.

  • Saying nothing in the answer and linking to a URL which in the future might be broken is a poor habit... – jonatr Jun 30 '20 at 14:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.