Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
81 | |
52 | |
39 | |
35 |
User | Count |
---|---|
95 | |
79 | |
52 | |
49 | |
47 |