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; } } }

ArcGIS for PowerBI

NisreenAlhindi

Could anyone clarify how I can connect to Microsoft Power BI without using any CSV files using ArcGIS Online hosted feature layer?

Please note that I am able to connect to all the features using ArcGIS For the PowerBI tool in the software but I need to use the fields and the data without exporting it as an excel sheet.

I hope my idea is clear.

Thanks in advance.

Regards,

Nisreen

Find more posts tagged with

Accepted answers

All comments

LeslieUK

Hi @NisreenAlhindi

I am not entirely sure what you are going for. If you are asking whether you can just use ArcGIS Online content on its own in the Power BI plugin, this is not possible. You must have data from Power BI to drive the plugin initially as it will be your data layer. The layers that come from ArcGIS Online are reference layers.

Faiez

Hi Nisreen!

Here are some steps to get connected to ArcGIS Online without using any CSV, PDF or excel files.

You have to open the ArcGIS Power BI first.

1. File>Options and settings>Options>Security>Check Use ArcGIS for Power BI>Ok

2. File>Options and settings> Data sources setting>Global permission> close

3. Home (in Power BI)>Get data>Web>Web views>Enable web previews>load data>check the files

4. Expand map tools> Add context>Reference layer> Select ArcGIS> Add your map or features layers.

Through the above mentioned steps I have got this:

Best,

Faiez

NisreenAlhindi

Dear Faiez,

Thank you for all of these details, I really appreciate them!

Actually, I have already done that but my concern was if there is any way to show the table fields instead of importing CSV or JSON format to PowerBI since this behavior will not reflect any live data on the charts and on the used tools if the feature layer data is updated on ArcGIS Online.

Best regards,

Nisreen.

NisreenAlhindi

Hello Dear,

Thank you for your response, I really appreciate it!

My workflow is adding a hosted feature layer from ArcGIS Online to PowerBI using the Map tool and that's working fine.

However, my concern if there is any was to show the table or layer fields on PowerBI without adding them as a CSV file or JSON format "Without GetData"

Regards,

Nisreen.

Faiez

Hi!

Without access to the data sources nothing could be happen. You can import simple excel files and from Data/Drill button you can turn it On/Off the visual table.

Export reports from Power BI to PDF Only 3070 pages.

Attached please also find ArcGIS Maps for Power BI.

Best,

Faiez

ArcGIS Maps for Power BI.pdf

CesarWesterhof

Hi

I'm trying to execute your instructions but cannot find what you explain in the 3d point.

After choosing web, there is no other option to choose. Which means that I miss "Web views>Enable web previews>load data>check the files" part. Please help.

After choosing "web" I het the following screen:

Please help.

Kind regards,

Cesar

Faiez

Hi Cesar!

Just write the URL, from where you want to bring more data, otherwise you can continue with your excel data. It provides additional sources.

Best,

Faiez

CesarWesterhof

Maybe you can help me with another issue. I' a newbie. I'm work at an organization that has GIS enterprise. I would like to count the quantity of connections inatlledd in certain areas. I live in a pretty small island, so GIS is not recognizing (neither the Microsoft maps component) addresses, cities, areas etc. But the company used GIS to getter GEO info of the connections. In GIS the connections can be seen on the map of Curacao. If I use the powerbi component I do not know what t use as GEO location. I'm combining data coming from an ERP system, but the geo location information is not in the ERP systems. After some research, a collegae told me that the globalId is being saved with the object connection information(in a table in ERP). I thought, maybe I can use the GlobalId in combination with the GIS component to show the connection on the map, but nothing is happening. I'm logging in Gis for powerBi component with my enterprise account. What I am doing wrong?

Faiez

Hi!

It depends to the type of your ERP system and GIS Server configuration and operating system. Try the ways that is easy and has been used before for extracting data from ERP system in your office. I think all data in ERP system store in one place that make it easy for all members to have accesses to it. You can get the number of connection through the Server by writing a formula or via excel data. ERP is integrated platform and it automatically collects the geo location data.

Good luck.

ZacharyHart

@Faiez Could you expand on this a bit please? are we providing a portal content URL, a service URL? Does this apply to web maps or only hosted feature layers...???

Faiez

Hi Zachary!

Yes, we can do many things with Microsoft Power BI, We can connect ArcGIS Online features hosted or other data to MS Power BI or vice versa from MS Power BI to ArcGIS Online.

1. Here is example from ArcGIS Online to MS Power BI.

2. In MS Power BI, after cleaning data or joining tables and finally publishing your data, you can embed it to website or portal, publish it to web or save it to PDF.

Best,

Faiez

NasreddineD

Hi,

This question has been solved if I understood your need.

Here are 2 tutorials to follow that can help you:

if your layer is public, you need to find the API rest link and follow this tutorial: https://community.esri.com/t5/arcgis-for-power-bi-questions/shape-in-geojson/td-p/1210801

if it is private : https://community.esri.com/t5/arcgis-online-questions/load-arcgis-online-data-into-power-bi-using-oauth2/m-p/1085577#M41557

VojtěchAndrš

Hello Faiez,

please, could you explain how to do the process the opposite way? That means getting data from Power Bi automatically to ArcGIS Online?

Thank you,
Vojtěch

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.