Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to Solution.
I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.
-proj wgs84
You can get the topoJSon here.
I tried simplifying the shapefile and converting to WGS84 using this command in MapShaper console option.
-proj wgs84
You can get the topoJSon here.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
85 | |
65 | |
51 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |