Rest API Access token using OAuth Token

MD39 — Mon, 11 Dec 2023 21:09:12 GMT

I'm trying to pull data using basic REST API calls, for example, https://api.powerbi.com/v1.0/myorg/admin/reports. When I go through https://learn.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-reports-as-admin

I am using Alteryx to download and parse the data, and when downloading using the API and getting the bearer token from https://learn.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-reports-as-admin it works and returns the data I need. However, I need to automate this so in my workflow, I want to pull a new access token when I run my workflow to use in any subsequent API calls. So, I have created an app in my azure portal and trying to call https://login.microsoftonline.com/{tenant id}/oauth2/v2.0/token for my authorization token to use in my get reports apiWhen I use that access token I receive a 403 error. Below is the post call i'm using to get the access token.

I've also tried using login.windows.net and this allowed me to use password as a grant_type and provided both an access and refresh token, yet both of those didn't work as expected.

My end goal, is to have a workflow that goes and gets the bearer authorization token to use for several calls available here

Re: Rest API Access token using OAuth Token

Anonymous — Tue, 12 Dec 2023 07:08:00 GMT

Hi MD39 ,

Based on my testing, even if you successfully generate an AAD token, the content permissions that your token can access are still determined by the value defined in the scope parameter, so if you want to run the Power BI API, you can try to define and fill in the scope parameter with this value

https://analysis.windows.net/powerbi/api/.default

At the same time, you can also make sure that the required scope of the application used to generate the token has been filled in using the delegated.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Rest API Access token using OAuth Token in Developer

Rest API Access token using OAuth Token

Re: Rest API Access token using OAuth Token