nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Find more posts tagged with

Power BI Desktop

Publish and Embed

Accepted answers

All comments

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-using-arcgis-for-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!!

SandeshLamichhane

Can we plot the shapefile containing road networks in power bi?

SandeshLamichhane

How can we plot polyline data or shapefile containing road data in power bi and use interactive slicers? Helps appreciated?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.