topic Re: Power Rest API Authorization Token Error in Developer

Power Rest API Authorization Token Error

Anonymous — Mon, 14 Jun 2021 19:13:34 GMT

Hello, I am trying to get an authroization token from Azure Service Principal using Postman and Power Query so I can query the Power BI Rest API but I keep getting an error. I cannot use a username and password to pull the data so we have set up a code and clientsecret. Has anyone had any experience setting it up? I have tried the configuration in POSTMAN and Power Quer

The URL I am using is: https://login.microsoftonline.com/<tenantid>/oauth2/authorize

Other parameters included in the body:

client_id

code

client_secret

grant_type: authorization_code

response_mode: query

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

I have also tried the following url https://login.microsoftonline.com/<tenantid>/oauth2/token

and I get an invalid_grant error

Other values set in the App Registeration are:

I am using the following code in Power Query

Re: Power Rest API Authorization Token Error

Watsky — Tue, 15 Jun 2021 17:53:49 GMT

Hey @Anonymous I haven't setup using authorization_code grant types before, but I have used client_secrets. Have you tried changing your grant_type to client_credentials? Try changing your grant type on https://login.microsoftonline.com/<tenantid>/oauth2/token

see if that works for you.

If that doesn't work for you take a look at this info

Microsoft identity platform and OAuth 2.0 authorization code flow - Microsoft identity platform | Microsoft Docs

You see towards the middle of the page how to use authorization_code grant types but it appears to have different keys than you're currently using.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Re: Power Rest API Authorization Token Error

Anonymous — Tue, 15 Jun 2021 17:57:05 GMT

Hello Watsky, When you mentioned grant_type client_credentials does that require username and password?

Re: Power Rest API Authorization Token Error

Watsky — Tue, 15 Jun 2021 18:27:07 GMT

No, these are the only keys I have listed when I run it in Postman

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Re: Power Rest API Authorization Token Error

Anonymous — Tue, 15 Jun 2021 18:24:18 GMT

Can you provide screenshot of the values you use for the above attributed?

Re: Power Rest API Authorization Token Error

Watsky — Tue, 15 Jun 2021 18:36:41 GMT

Sure at least everything but my client_id and secret. Also, I'm on GCC so my resource is a bit different, so no need copying that over.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Re: Power Rest API Authorization Token Error

Anonymous — Tue, 15 Jun 2021 18:58:10 GMT

So I was able to get an authorization code, but when I use it in within Power BI, it expects me to sign in, that shouldnt be requirement right?

Re: Power Rest API Authorization Token Error

Watsky — Tue, 15 Jun 2021 22:11:30 GMT

It shouldn't be I just tested and I have my credentials set to Anoynmous.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Re: Power Rest API Authorization Token Error

Anonymous — Wed, 16 Jun 2021 14:39:51 GMT

Could you share your Power Query Code for getting token and using that token in the call to get workspaces just so that I can confirm I got everything in there? Also, can you confirm the settings in Azure I have made?

Re: Power Rest API Authorization Token Error

Watsky — Thu, 17 Jun 2021 13:45:42 GMT

as for your Azure settings. Has an admin granted privledges for the permissions? Looking at mine I have a granted/not granted by all of the permissions.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Re: Power Rest API Authorization Token Error

Anonymous — Thu, 17 Jun 2021 17:55:50 GMT

Everything above is the same. I get an unauthozed 401 message in Postman when I use the authorization code generated in Power BI. My guess is there is something different in Azure config.

Re: Power Rest API Authorization Token Error

Anonymous — Mon, 21 Jun 2021 06:10:10 GMT

Hi @Anonymous.

I'd like to suggest you check if you used the same account on the power bi side which assigned the api permissions on the Azure side.

For this scenario, you can also contact azure support to trace the requests to get further information and support for troubleshooting.

BTW, it seems like you are work with admin API, have you assign the power bi admin permission on the test account?

Regards,
Xiaoxin Sheng