Hi everyone,
I am for the first time trying to get data from an API into Power BI Desktop using Advanced Editor to write the proper information in.
I can connect, get a list of reports but can't find out how to actually load a report in Power BI. The documentation of the API mentions this:
"GetReportData
This method takes one or more reportIds and a callbackUrl. Because it can take a significant amount of
time to download the report information, this is an async call. The resulting data will be send via a POST
request to the supplied callbackUrl."
This is my M-code to fetch report 250:
let
url = "https://xxx.nl/api/GetReportData?reportIds=250&callbackurl=xxx",
body="grant_type=client_credentials&client_id=TReasuryAPI&client_secret=xxx&scope=Treasury",
Source = Json.Document(Web.Contents(url,
[
Headers = [Authorization="Bearer " & "xxx",
#"Content-Type"="application/x-www-form-urlencoded"],
Content=Text.ToBinary(body)
]
)
)
in
Source
I need to give a value to the callbackurl (xxx is a placeholder), but what? Or is this something that Power BI Desktop does not support?
I have a short line to the person that build the API and he mentioned he might add a API call to fetch one report at a time, not using a callbackurl. Is that a good solution for my scenario?
Thanks in advance!
