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!