Visualize map polygons in PowerBI

[Falco_PowerBI]

Hi all,

I would like to visualize GIS polygons based on wgs84 coordinates in PowerBI. Untill now I only was able to visualize points. Does anyone know how this can be done? If not, are there any workarounds? Or when will PowerBI add this feature?

Thanks for your help!

Kind regards,

Falco 

[Anonymous]

Hi Falco,

We just added this in the ArcGIS Visual and we will be blogging on it soon. You can use a shape field for Location and we'll read it. There are some limitations with Power BI that can cause some issues. 

For example, a state counties dataset is polygon geometry. If the shape of polygon as a string is 40000 characters, it will get truncated at 32766 (the limit) causing the JSON string to be invalid and our code cannot parse the JSON shape. So we'll have some reccomendations on how to trim the characters to fit within the limits. 

Stay tuned,

Andrew

[Falco_PowerBI]

Hi @Anonymous ,

Do you mean that polygons will be added soon to the ArcGIS map visual? That would be cool! When will it be ready?

[Anonymous]

Hello Falco,

The ability is there now if the polys are in Esri JSON format. 

https://doc.arcgis.com/en/power-bi/get-started/prepare-your-data.htm

We have a few blog posts on how to convert this, but right now working to squash a bug or two that slipped out on Tuesday. 😬

[Anonymous]

@Falco_PowerBI 

Whether to consider the ArcGIs Map visual object:

You can get the custom visual via below:

https://appsource.microsoft.com/en-us/product/office/WA104379588?tab=Overview

For reference,you can check the video inside via below link:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-arcgis

https://community.powerbi.com/t5/Desktop/ArcGIS-for-Power-BI-questions/td-p/1832601

Best Regards,

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

[amitchandak]

@Falco_PowerBI , Are you looking for shape MAP ?

Map Json - Shape 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/
https://medium.com/weareservian/power-bi-custom-maps-part-ii-shape-map-939873da3f66