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.