Publish a choropleth map (boundaries, not points), publicly, using ArcGIS for PowerBI

[LucasEsri]

I need to use Power BI with ArcGIS to publicly publish a map that plots my data delimited by the boundaries of each Brazilian municipality (a choropleth / filled map type).

I am using a Power BI Premium per User account, and I was already able to publish a map with data POINTS.

The link below has many tests using different Power BI's maps, but page 2 has the ArcGIS map with data points

Published-Power-BI-Report

What I need is to plot my data in municipality BOUNDARIES. I can do it offline, but I can't publish it online because it fails the coordinate validation test from ArcGIS. This map is in the first page from the link, but all you can see is an error message from Power BI.

Here is a google app presentation with a full explanation of what I already tried:

google-presentation-wider-explanation-about-the-problem

I asked for help from Microsoft, but they said I had to ask Esri for support, as this kind of Power BI visual is developed by them.

Then I tried Esri support, but they did not provide it, as I did not have an ArcGIS paid subscription (even though I bought a Power BI Premium Subscription).

So, I decided to ask for help here. Thanks in advance for any help.

[NaZhang_Esri]

Hi @LucasEsri,

Thanks very much for your question and the very detailed information. To embed/publish a report using polygons or polylines, they have to be in EsriJSON format, that way, it can pass the validation check. Please make sure not to add data to XY and Location field wells at the same time. To publish an ArcGIS layer, the layer needs to be public. 

Please check this link to see if it helps. https://www.esri.com/arcgis-blog/products/power-bi/sharing-collaboration/sharing-reports-in-power-bi...

And let me know if you have any other questions. Thank you!

[LucasEsri]

Hello @NaZhang_Esri , thanks for your reply!

But how can I create the EsriJSON file? Do I need an ArcGIS Pro subscription as well?

And is there a way to convert a GeoJSON file to it?

Also, where do I use the EsriJSON file? Is it through PowerBI, or do I have to create the layers using ArcGIS Online and then load the layer in the ArcGIS map in PowerBI?

[NaZhang_Esri]

Hi @LucasEsri,

Thanks for your question! If you prefer a non coding solution, check out this link https://storymaps.arcgis.com/stories/dc0c7f9ab73c469aaea407213d0883a1 . If you go to Using ArcGIS for Power BI part and keep scrolling, there's an Add data part explaining how to get EsriJSON data and there's a short video demonstrating how to map the geometry data.

[MdeBoer]

Hi,

I found that the URL that @NaZhang_Esri sent is missing a character. I looked it up in ArcGIS Online, here is the complete URL: https://storymaps.arcgis.com/stories/dc0c7f9ab73c469aaea407213d0883a1

Best,

Menno

[NaZhang_Esri]

@MdeBoer - Good catch! I've corrected the link there. Thank you!!