Get data from API With authorization

[Talsofir]

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?

[v-yueyunzh-msft]

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":

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/dashboards-get-dashboards-as-admin?tryIt=t...

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