Forum Discussion
Helper IPower BI Admin API access with client secret no access to the admin side
Community ChampionHi, Benedikt_Sch
-
Make sure the Azure AD application registration includes permissions specifically for the Power BI Admin API. This usually means having Tenant.Read.All or Tenant.ReadWrite.All permissions within the Power BI service permissions set. These permissions require admin consent (which you've mentioned you've already done, but it's worth double-checking).
-
Admin consent needs to be given at the tenant level. Sometimes, even if permissions appear to be correctly set, the consent might not have been properly applied. Revisit the admin consent process to ensure it's been granted for the permissions necessary to use the admin API.
Check the link below if you missed anything
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal
Ensure that this security group is designated as a Power BI service admin group in the Power BI Admin Portal.
Also, Can you try refreshing or creating the secret for admin and try again?
- Benedikt_Sch
Hi rubayatyasmin ,
thanks for the quick answer!
I double checked the mentioned points:
- Tenant.ReadWrite.All and als other possible permissions are granted and also granded as Admin
- API and ADMIN API in Power Bi has the sec-Group as Member
- New secret creaded
Sadly no succes.
I found GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API and this works quite good in my Case. Maybe is it the only solution here. Chris webb also mentioned that the admin API is not working in power query.
Thanks and best regards.