Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Access token lacks authorisation

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!

  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      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!

      • Kapilnathgbp's avatar
        Kapilnathgbp
        New Member

        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