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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SteffH
Regular Visitor

Need some help with API call Power BI

so i have an API link to get data, it requires simply a post command with the api link and some body information

 

the body info is as followed:

SteffH_0-1682925198546.png

 

 

This works fine in Postman and I get the data in JSON format, but im curious how i can do the same in Power BI. Any help is appreciated


 

 

Also a second thing would be to make a script to receive the access token (the priority goes out to the one above)

 

It's a simple Post login link where the body is as follows:

 
 
 

Untitled.png

 

So the password and username and domain is given in the body, not in the authorization tab in Postman.

1 REPLY 1
Anonymous
Not applicable

Hi  @SteffH ,

You can refer the following links to connect API in Power BI Desktop by web connector:

How do I connect to REST APIs with Power BI? (Part 1)

Chris Webb's BI Blog: Working with Web Services in Power Query

Web.Contents(
  "https://www.regonline.com/api/default.asmx/GetEvents",
  [
   Query=[ #"filter"="", #"orderBy"=""],
   Headers=[#"APIToken" = "insertAPITokenHere"]
  ])

Read API Data with Power BI using Power Query

vyiruanmsft_3-1683084364020.png

 

And about how to get access token, you can refer the following video to get it.

Building a Power BI Admin View [Part 2]: Obtaining a Refreshable Access Token

Get access tokenGet access token

vyiruanmsft_2-1683084259856.pngBest Regards

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.