PBI Access Token API

[ekimakIA]

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 powerbi username and password. But still I'm not getting pbi access token.

[ekimakIA]

Hi,

Using this access token URL "URL: https://login.microsoftonline.com/common/oauth2/token" Im getting the access token but when I pass this token in "Export Report In Group" API. We are getting unauthorized.

This authentication is not working for Report API. 

[ibarrau · Accepted solution]

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]

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,