Forum Discussion

ekimakIA's avatar
ekimakIA
Frequent Visitor
4 years ago
Solved

PBI Access Token API

Hi,   I'm  trying to fetch pbi access token with this below api but I'm getting issue while executing this API.   API : https://token.docs.microsoft.com/accesstokens   In the header I'm passing...
Need Help
  • ibarrau's avatar
    ibarrau
    4 years ago

    Hi. If you are getting a token that means the authentication is working perfect. The Unauthorized means that the ClientId doesn't have permission to do that.

    Be sure that you have what you need. Each request in the API has in its document the scope. For example the scope for exporting report in group is:
    Required scope: Report.ReadWrite.All or Report.Read.All

    Check your delegated permission in the app registered to validate that.

    I hope that make sense

ibarrau's avatar
ibarrau
Super User
4 years ago

Hi. Assuming you are talking about the accessToken for the Power Bi API

https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token

I can say you shouldn't sent that in the headers.

The access token is requested with a post method like this:

URL: https://login.microsoftonline.com/common/oauth2/token

Header: Content-Type: application/x-www-form-urlencoded

Body:

    data = {
        'grant_type': 'password',
        'scope': 'openid',
        'resource': 'https://analysis.windows.net/powerbi/api',
        'client_id': power_bi_client_id,
        'username': power_bi_username,
        'password': power_bi_password
    }

The last three items need to be changed. The clientid of your registered app, user and password. If you want to coonect with a service principal it might be a little different.

I hope that helps,