Forum Discussion

op-agw's avatar
op-agw
Regular Visitor
1 year ago
Solved

Power BI REST API, HTTP 401

Hi all,

 

I've been able to successfully test connectivity of my App registration using the codebase, against the default `https://graph.microsoft.com/v1.0/users`

Azure-Samples/ms-identity-javascript-nodejs-console: A Node.js console daemon application secured by MSAL Node and calling Microsoft Graph API via OAuth 2.0 client credentials flow (github.com)

 

When attempting to test against the Power BI endpoints, I get a HTTP 401

 

As a quick test, I made the following changes on the codebase, to file `./bin/auth.js:21`

 

```

const tokenRequest = {
};

const apiConfig = {
};
```

 

API permissions on the app

The delegated permissions will be removed, as we will be building a Node-based daemon - we added the only `ReadWrite` permission that was displayed for Power BI, for application permissions.

 

 

Would appreciate any help or suggestions; as it's looking as if this setup isn't possible? Thanks.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from Tayyabali , please allow me to provide another insight:

    Hi, op-agw .

    HTTP 401 errors typically indicate authentication issues. Here are some possible workarounds:

    1.First, check the access token: Make sure your application provided a valid access token in the request. The access token may be missing, invalid, or expired.

    Here is a screenshot of the relevant documentation:

    Resolve Microsoft Graph authorization errors - Microsoft Graph | Microsoft Learn

    2.Second, confirm that the permissions are sufficient: Make sure that you have assigned the correct API permissions to your application in the Azure portal and that they have been granted by the administrator.

    3.Next, make sure the Power BI service admin permissions are turned on

    4.Finally, debug tokens: Use a tool such as JWT.io to decode your access token, checking the permissions and expiration date in it

    https://www.bing.com/search?q=JWT&form=ANNH01&refig=8661f8975dce4c1cb424494de4564ef1&pc=U531

    Of course, if you have any new ideas, you are welcome to contact us.
     

    Best Regards,

    Leroy Lu

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

3 Replies

  • Power BI REST API, HTTP 401

    16m ago

    Hi all,

     

     

     

    I've been able to successfully test connectivity of my App registration using the codebase, against the default `https://graph.microsoft.com/v1.0/users`

     

    Azure-Samples/ms-identity-javascript-nodejs-console: A Node.js console daemon application secured by...

     

     

     

    When attempting to test against the Power BI endpoints, I get a HTTP 401

     

     

     

    As a quick test, I made the following changes on the codebase, to file `./bin/auth.js:21`

     

     

     

    ```

     

    const tokenRequest = {

    scopes: ['https://analysis.windows.net/powerbi/api/.default'],

    };

     

    const apiConfig = {

    uri: 'https://api.powerbi.com/v1.0/myorg/groups',

    };

    ```

     

     

    API permissions on the app

     

    The delegated permissions will be removed, as we will be building a Node-based daemon - we added the only `ReadWrite` permission that was displayed for Power BI, for application permissions.

     

     

     

    Screenshot 2024-09-02 at 12.13.09.png

     

     

     

    Would appreciate any help or suggestions; as it's looking as if this setup isn't possible? Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the reply from Tayyabali , please allow me to provide another insight:

    Hi, op-agw .

    HTTP 401 errors typically indicate authentication issues. Here are some possible workarounds:

    1.First, check the access token: Make sure your application provided a valid access token in the request. The access token may be missing, invalid, or expired.

    Here is a screenshot of the relevant documentation:

    Resolve Microsoft Graph authorization errors - Microsoft Graph | Microsoft Learn

    2.Second, confirm that the permissions are sufficient: Make sure that you have assigned the correct API permissions to your application in the Azure portal and that they have been granted by the administrator.

    3.Next, make sure the Power BI service admin permissions are turned on

    4.Finally, debug tokens: Use a tool such as JWT.io to decode your access token, checking the permissions and expiration date in it

    https://www.bing.com/search?q=JWT&form=ANNH01&refig=8661f8975dce4c1cb424494de4564ef1&pc=U531

    Of course, if you have any new ideas, you are welcome to contact us.
     

    Best Regards,

    Leroy Lu

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