Além do token, outros parâmetros são importantes para viabilizar a consulta de serviços seguros do ArcGIS Enterprise no Microsoft Power BI. Neste vídeo demonstraremos passo a passo como realizar esta tarefa.

 

Script para uso no Power BI:

let

GetJson = Json.Document(Web.Contents(“Portal WebAdaptor URL“, [

RelativePath=”sharing/rest/generateToken”,

Headers = [

#”Accept” = “application/json”,

#”Content-Type” = “application/x-www-form-urlencoded;charset=UTF-8”

], Content=Text.ToBinary(“Token Complemento“)

])),

#”Converted to Table” = Record.ToTable(GetJson),

Token_ = #”Converted to Table”{0}[Value],

Feature_Service_Token = Json.Document(Web.Contents(“ArcGIS Enterprise URL“, [

RelativePath=“Feature Service URL“,

Query=[

where=”1=1″,

outFields=”*”,

returnGeometry=”false”,

f=”json”,

token = Token_

]]))

in

Feature_Service_Token