Forum Discussion

tripleacoder's avatar
tripleacoder
Helper I
7 years ago
Solved

Power Bi REST API - 401 Authorization error when using app secret

I have a console app that uses the REST API to get a dataset (and later add rows to it). This works when I supply my own user/password credentials.   Now I have registered the app as a Web/API app ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi tripleacoder,

     

    As far as I know, the permissions of Power BI are all based on the users. So an App can't act as a user. Please refer to developer/power-bi-permissions where all the descriptions have "user". 

    Regarding "Tenant.ReadWrite.All", the documentation above also has a description. Actually, these permissions only can retrieve the profiles rather than data. Please refer to admin/reports_getreportsasadmin.

    One simple proof we can see is that even an admin can't access all the App workspaces. The data is the precious asset of a company. I think this is reasonable.

     

     

    Best Regards,
    Dale

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, did you solve it, appreciate for your response, thanks!

pvuppala's avatar
pvuppala
Helper V
2 years ago

Ended up using personal account to run the PowerShell script.  Eventually would like to use Power Automate via Service Principal client/secret.