topic Re: Adding ArcGIS Online Data to Power BI Map in ArcGIS for Power BI Questions

Adding ArcGIS Online Data to Power BI Map

MikeMacRae — Wed, 09 Jun 2021 18:34:04 GMT

I started a report in Power BI for Desktop. I have an ArcGIS for Power BI account. I added an 'ArcGIS Map for Power BI' map to my report. When added, it asks you to log into your organizational account, which I have. I now have the following Screen:

MikeMacRae_0-1623261950721.png

It appears that, in order to get the map to populate, one has to add some data from a Power BI datasource (drag a field to the 'Location' field under the 'Visualizations' panel) and then a map appears.

Instead, I want to start by adding some data from my ArcGIS Account which is possible from the Analysis Tools widget in the map

MikeMacRae_1-1623263377246.png

But in order to get a map to open, all I can figure is, you have to drag some data into the 'Location' field first. Is there any way to get a map to open without having to do this?

Note: I tested by dragging some data to the 'Location' field just to get the map to open, thinking I could just remove it from the map afterwards, but there is no option to remove that data layer from the map:

MikeMacRae_2-1623263555147.png

Re: Adding ArcGIS Online Data to Power BI Map

JonEmch — Thu, 10 Jun 2021 13:21:32 GMT

Hey there Mike,

ArcGIS for PowerBI is first and foremost a mapping visualization tool that must have data from PowerBI to work. You are correct, to start any operations within the visualizer, you have to populate the Location Field Well (Or lat and Long). The visualizer will then become functional and allow you to pull in data from ArcGIS Online.

Re: Adding ArcGIS Online Data to Power BI Map

MikeMacRae — Thu, 10 Jun 2021 15:05:56 GMT

I outlined that as an issue in my post. After dragging the data into the Location field for the sole purpose of getting a map to populate so I can use the data I actually want to use from AGOL, is useless for my usage case.

Re: Adding ArcGIS Online Data to Power BI Map

BrittanyBurson — Tue, 12 Oct 2021 18:26:24 GMT

Thanks @MikeMacRae for posting... had the same question.... seems like integrating ArcGIS Online/Enterprise layers is mostly for map visual reference only, rather than as a data source for analytical cards/visuals.

Re: Adding ArcGIS Online Data to Power BI Map

JoabelBarbieri — Thu, 14 Mar 2024 12:18:46 GMT

Same question here. I want to be able to use the data tables and layers stored in AGOL as datasource in PowerBI. The current ArcGIS for PBI is too basic and not worth of its name I'd say....

Re: Adding ArcGIS Online Data to Power BI Map

NateHollenbeck — Thu, 18 Apr 2024 20:15:24 GMT

I may have found a solution for you. I was able to successfully connect to my ArcGIS Online data that was publicly available. I have not yet figured out how to pull data that is private. I hope this helps @MikeMacRae @JoabelBarbieri @BrittanyBurson

How to use ArcGIS with Power BI - Resource Centre | Esri UK

Re: Adding ArcGIS Online Data to Power BI Map

AdamVellutini — Thu, 06 Jun 2024 18:48:26 GMT

Hello, @NateHollenbeck. I am just starting to play around with this and can add data that is publicly available. Having a hard time figuring out how to pull in private data; none of the options I see are working. Were you able to figure that out? It's mentioned in the post and in other places, but nothing seems to work for me. My hope is that a user can sign in with their AGO credentials and see data shared to them. Thanks! -Adam