ArcGIS data connection for Power BI

1601
9
08-18-2017 09:39 AM
Status: Open
YoavRappaport
Occasional Contributor

Create a data connector to ArcGIS Online feature services from Power BI. This would allow the reading of tabular data from hosted feature services either in public or preferably in organization layers.

9 Comments
BrettShaver

This would be a fantastic functionality that our organization needs

EricO_Neal1

The query function returns JSON, so you can do this already.  Create a blank query and use:

let
Source = Json.Document((Web.Contents("http://YOURFEATURESERVICE/x/query?where=1%3D1&t...&f=pjson&token=xxx")))
in
Source

Then convert to table and expand list fields.

DavidCresp

This feature is really badly needed. Being able to connect to data in our corporate layers is the big missing part of this visual. You can do it in MapBox Power BI visual, why can't we do it in our corporate Esri system. Please, please bring this in.

KoryKramer
Status changed to: Open
 
RodrigoLama

Necesitamos esta característica  urgente. Siempre somos los últimos en tener estas entradas a Microsoft.

WilliamBernis

SI alguien me puede ayudar con este tema le quedo totalmente agradecido, tengo un survey que necesito conectarlo a Power BI pero aún no lo logro.

RodrigoLama

Forget about connecting with powerbi for the moment, ESRI, wants us to use their product "Operation Dashboard" that after giving me to him, I am quite enchanted with everything that can be done.

Billy
by

This functionally is badly need. Operational Dashboard covers some of the functionality that PowerBI offers but not all of them. For example accessing Arcgis Online/Enterprise layer's data when creating a PowerBI paginated report will be great feature for people that already use these reports.  

IsadeMorais

Indeed it is very important to have that feature!!