Forum Discussion

cporteous's avatar
cporteous
Most Valuable Professional
8 years ago
Solved

Gateway info from Power BI API in PowerShell

Hi,   So Ive got all manner of data out of the Power BI REST API using PowerShell, using both a Native & Web app.   Im trying to hit this API and getting a 401 across the board though I got it wo...
Need Help
  • izurev's avatar
    izurev
    8 years ago

    Login to Azure portal with the user that you use for the API requests and navigate to the APP and then click on Required permissions and then click Grant Permissions. This will assign all permissions to that user (11 permissions for Power BI Service). That solved the issue for me.

     

    You may also need to generate a new login token for the user after that...

     

    Let me know if that worked for you.

     

     

izurev's avatar
izurev
Frequent Visitor
8 years ago

how was this solved?

I'm having the same issue - seeing 401 error when querying for the gateways using the Power BI API - other endpoints are working fine.

Also, checked and i see all 11 delegated permissions on the App side.

 

Thanks in advance,

Alex

cporteous's avatar
cporteous
Most Valuable Professional
8 years ago

I still don't have this solved.

 

The app can query all other aspects of Power BI through the API but always returns a 401 for Gateway calls

  • izurev's avatar
    izurev
    Frequent Visitor
    8 years ago

    Login to Azure portal with the user that you use for the API requests and navigate to the APP and then click on Required permissions and then click Grant Permissions. This will assign all permissions to that user (11 permissions for Power BI Service). That solved the issue for me.

     

    You may also need to generate a new login token for the user after that...

     

    Let me know if that worked for you.

     

     

    • cporteous's avatar
      cporteous
      Most Valuable Professional
      8 years ago

      That's it. I needed to force the prompt for login. Refreshing the token alone didn't fix it. It looks like I needed to just Grant Permissions from within Azure. Its weird as I tried this months ago with no success. May have been a localised issue to my tenant or some other permissions problem.

       
      Thanks! It's always the little things eh!
      • izurev's avatar
        izurev
        Frequent Visitor
        8 years ago

        I find all these "settings" not very intuitive... 

        Glad to know that this is working for you now :)

         

        Cheers,

        Alex

         

    • cporteous's avatar
      cporteous
      Most Valuable Professional
      8 years ago

      Tried that.

       

      The app has 13 permissions too.

       

      Did you create FROM Power BI or from Azure?

      • izurev's avatar
        izurev
        Frequent Visitor
        8 years ago

        Created the app from Azure as Native.

        Also, you might also want to try to generate the token using prompt - to input the user/password again - maybe it will also prompt you for the new permissions (make sure that neither of the selected permissions need Admin).

        And check that the user is set as Admin on the Power BI Portal side for at least one Gateway.