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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
SparkDataGuru
Frequent Visitor

Shape Map - Incorrectly Displaying

Recently I downloaded the shapefile for FSA boundaries for Canada found on the Government of Canada's site (https://www12.statcan.gc.ca/census-recensement/2021/geo/sip-pis/boundary-limites/index2021-eng.cfm?y...

After I converted the shapefile to TopoJSON using MapShaper (https://mapshaper.org/) as recommended by the Microsoft's support page (https://learn.microsoft.com/en-us/power-bi/visuals/desktop-shape-map) regarding Shape Map utilization. 

 

Initially I tried using the biggest file, it seemed too detailed to properly load on my Power BI Desktop (actually crashed my program), so I used a simplified file (using MapShaper's simplify tool) and added the file to Power BI again at a much smaller file size. It's now displaying however, the image is glitched/incorrect, with verticies converging to the bottom left corner of the box... anyone have recommendations on how I can properly get Canada's FSA boundaries to properly display? FSA mapshaper fail.png

1 ACCEPTED SOLUTION
Danyel79
New Member

I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.

 

-proj wgs84

 

You can get the topoJSon here

 

Danyel79_0-1675884572813.png

 

View solution in original post

5 REPLIES 5
Danyel79
New Member

I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.

 

-proj wgs84

 

You can get the topoJSon here

 

Danyel79_0-1675884572813.png

 

Thank you Danyel! I tried the file you provided and simplified it. Its displaying properly on Power BI now! 

I do have a question regarding simplifying, I'm not too familiar with mapping tools like these, on MapShaper for simplifcation, which settings boxes did you tick off for 'Simplification' and 'Method' (Douglas-Peucker, Visvalin Effective Area, Visvalingam Weighted Area, etc) , also how much % did you lower it to for Power BI to process it properly? 

I simplified to 20% and it's still quite big. You can probably find a map that's already simplified.

 

Some of this algorithms can be quite complex, you can read more on wikipedia for example.

https://en.wikipedia.org/wiki/Ramer%E2%80%93Douglas%E2%80%93Peucker_algorithm

https://en.wikipedia.org/wiki/Visvalingam%E2%80%93Whyatt_algorithm

 

I got it down to around 5% and it loaded. Appreciate your help!

HotChilli
Super User
Super User

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors