ArcGIS data connection for Power BI

987
4
08-18-2017 09:39 AM
Status: Open
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.

4 Comments

This would be a fantastic functionality that our organization needs

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.

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.

Status changed to: Open