Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi everybody
Interested in connecting an API to my reports in POWE BI,
I have a url
And to access the address is required to provide as part of the application
Authorization
When I try to access the data via the web, and click advanced, there is no authorization option in the list.
It should be noted in postman that when I make a POST request to the url
and add the details in the headers, I get proper JSON
Does anyone know how to help?
HI , @Talsofir
Based on my test and your issue requirement description, you want to achieve the "access the data via the web" and have already achieved the same API request sending using the Postman tool, but need some help to achieve the same thing using the Power BI desktop tool, right?
If I'm understanding correctly, actually you can try to add the "Authorization" part manually to enter the name and token in the "Https header parameter":
For example, I want to connect to the Power BI admin rest API "Get dashboard in group":
I can try to put the URL and the "Authorization" part manually to enter the name and token in the "Https header parameter" like this, then select "Anyonmous", the data will be connected successfully with data loaded:
Regarding the detailed M code used to connect to the web API data and get the result in the Power query part, please detaield refer to the "Web.Contents":
https://learn.microsoft.com/en-us/powerquery-m/web-contents
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 50 | |
| 43 | |
| 36 | |
| 33 | |
| 30 |
| User | Count |
|---|---|
| 138 | |
| 125 | |
| 60 | |
| 59 | |
| 56 |