AnsweredAssumed Answered

Accessing ARCGIS Server URL in Power BI

Question asked by cliveswan on Mar 26, 2020
Latest reply on Mar 27, 2020 by cliveswan

Greetings,

 

I am trying to access an ARCGIS Server URL in Power BI.

 

I read that you can use a Power BI query, would like some clarity on the query format.

The query is:

let
Source =son.Document((Web.Contents("query&f=pjson&token=xxx")))

in

Source

 

I presume the token is from ArcGIS Portal Admin??

 

I copied the URL below from the ArcGIS Manager Query tool.

 

https://<server>/server/rest/services/Nag/CCGPostcodeMap/MapServer/1/query?where=1%3D1&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&distance=&units=esriSRUnit_Foot&relationParam=&outFields=PostArea&returnGeometry=false&returnTrueCurves=false&maxAllowableOffset=&geometryPrecision=&outSR=&havingClause=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&historicMoment=&returnDistinctValues=false&resultOffset=&resultRecordCount=&returnExtentOnly=false&datumTransformation=&parameterValues=&rangeValues=&quantizationParameters=&featureEncoding=esriDefault&f=pjson

 

Do I need to copy the whole string??

 

Thanks,

 

Clive

Outcomes