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=¶meterValues=&rangeValues=&quantizationParameters=&featureEncoding=esriDefault&f=pjson
Do I need to copy the whole string??
Thanks,
Clive
I want to use the ArcGIS basemap with json as the format, so used the blank query.
let
Source = Json.Document((Web.Contents("https://www.arcgis.com/home/webmap/viewer.html?webmap=55ebf90799fa4a3fa57562700a68c405&f-pjson")))
in
Source
This returned an error:
There are extra characters after the json ??