Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tamerlane
Helper I
Helper I

Get data from API that uses a callbackurl

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! 

1 REPLY 1
Tamerlane
Helper I
Helper I

Anyone?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors