topic Re: Access token lacks authorisation in Developer

Access token lacks authorisation

Anonymous — Tue, 13 Jul 2021 16:09:22 GMT

Hello troops, I am trying to develop an Azure application with PowerBI embedded.

I am currently stuck at the point of making an API call to get an access_token that will allow me to push a dataset in a specific group.

I have been looking for hours and I was unable to find a solution that allows me to do so.

So far, I have managed to create an API on Azure and give that API all the possible Power BI Service permissions (See photo below)

Furthermore, what I think I am doing via postman is reaching out to that API and getting validated, as you will see in the next picture

This returns an access_token back, however, this token does not have any permissions as far as I can tell. I have tried getting reports, datasets, dashboards but to no avail.

If anyone could give me some help here I would very much appreciate it!

Re: Access token lacks authorisation

Anonymous — Thu, 15 Jul 2021 09:18:37 GMT

Hi @Anonymous

There may be something wrong to your access token.

Could your tell me which kind of your Azure App is, app owns data or user owns data?

There are two kind of authentication method for app owns data, service principle or master user?

I see in your Body you have password and username, if you use user owns data or master user, please use Password in grant_type, if you use service principle , use client_credentials in grant_type.

From your screenshot of API Permission, I find that your didn't grant admin consent for you permissions.(App owns data —— Master user or user owns data need this.)

API Permission configured correctly looks like as below.

Then please check your api resouce, the resource url should be https://analysis.windows.net/powerbi/api .

Best Regards,

Rico Zhou

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

Re: Access token lacks authorisation

Anonymous — Thu, 15 Jul 2021 09:33:32 GMT

Thanks for your reply @Anonymous. Indeed the problem was with the authorisation token, I contacted my administrator and asked him to grant permissions to the token. It now works flawlessly!

Re: Access token lacks authorisation

Kapilnathgbp — Thu, 28 Jul 2022 15:48:27 GMT

I am still not able to resolve my issue, could you tell me what all permissions did you give in Azure direcotry and also how are you calling the post method to request for the token? In my case i have client secret , how to request access token without providing username and password