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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.