Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jodes
Helper II
Helper II

.JSON shapefile not showing up properly

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

 

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:

Map.JPG

Does anyone have any ideas?

 

Thank you.

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

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

2 REPLIES 2
LijunChen
Resolver I
Resolver I

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
Super User
Super User

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.