Accessing ARCGIS Server URL in Power BI

Question

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=xyz")))

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=1&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

CliveSwan · Answer

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 ??