cancel
Showing results for 
Search instead for 
Did you mean: 
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
Helper I
Helper 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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors