Does Power BI (automatically) recognize Canadian FSA data at all?

[pborah]

First off all, I cannot use ArcGIS due to security and licensing issues -

Now that we've settled that, how do I get PowerBI to recognize Canadian FSA data? It works right out of the box in Tableau where I just need to drop the FSA column onto the map and it creates those filled polygons on top of the map.

Alternatively, if I can find a shp or kml file containing the FSA polygons say from StatsCan, how easy or hard is it to get it to work with the rest of my data in Power BI? I'm using Report Server Jan 2020 compatible version of Desktop.

Following are some of the columns in my main dataset -

incident #, incident time, resolution time, resolution duration, district, municipalty, FSA, province, etc. Thank you.

[v-lionel-msft]

Hi @pborah ,

Please refer to this link for detailed steps.

Add custom reference layers to ArcGIS Online 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pborah]

thanks @v-lionel-msft , if you read my original post, it shows that arcGIS is not an option for me due to licensing issues. As a result the good folks at infrastructure have turned off arcGIS maps capability of Power BI. Thank you.

[amitchandak]

@pborah , You can explore the shape map. You can choose the require map or use json map

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map

https://dataveld.com/2016/09/12/topojson-map-files-for-power-bi-shape-map/

[pborah]

Thanks @amitchandak , I already found the articles before posting here. The second one is irrelevant to me. I asked for the capability to read shp, kml, etc. files. My problem is that I do not have a shape map visual available. Perhaps this is because I'm using a report server version? I also do not have preview features under option. Infact I found that PowerBI cannot even ingest a simple spatial file like Tableau.

Additionally, and I say this with utmost respect.... might I ask you to make some actual suggestions instead of replying with urls to my questions all the time? Thanks. 🙏