Solved: .JSON shapefile not showing up properly

Jodes · ‎05-25-2019

I tried to convert my shapefile into .JSON so I can import it into PowerBI but it is not working. See image below.

I used mapshaper.org to convert it from .SHP to .JSON. It looks fine on the website when I convert it, but the end result is off. This is the result:

Does anyone have any ideas?

Thank you.

d_gosbell · ‎05-26-2019

For geographic data there are multiple different reference systems and projections. It looks like your original shp file is using a reference system that PowerBI does not support. Try following the steps suggested in this article https://dataveld.com/2016/09/01/overcoming-potential-power-bi-shape-map-rendering-issues/ I had an issue like this months ago and I think converting to the wgs84 projection using mapshaper (as suggested in the linked article) fixed this for me.

View solution in original post

LijunChen · ‎01-05-2023

Many thanks for providing the links to the article. I came across the same problem while rendering a State county boundary map in Power BI. I followed the instructions and used Mapshaper Console command to changed the reference system as proj wgs84 -o and saved as a Json file. And now Power BI shape map can read and display the data correctly.

d_gosbell · ‎05-26-2019

For geographic data there are multiple different reference systems and projections. It looks like your original shp file is using a reference system that PowerBI does not support. Try following the steps suggested in this article https://dataveld.com/2016/09/01/overcoming-potential-power-bi-shape-map-rendering-issues/ I had an issue like this months ago and I think converting to the wgs84 projection using mapshaper (as suggested in the linked article) fixed this for me.