Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
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:
So the password and username and domain is given in the body, not in the authorization tab in Postman.
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
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 token
Best Regards
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
4 | |
4 | |
4 | |
3 |