Forum Discussion
Power BI Admin Rest API's
Hello Team,
With the help of below custom connector able to connect all the tables except the Admin Rest API’s Table.
https://github.com/migueesc123/PowerBIRESTAPI
Tried contacting the Owner of the connector and he suggested to contact the Microsoft to check why not able to load the admin’s admin API’s table and you can see the conversation history in the below link..
https://github.com/migueesc123/PowerBIRESTAPI/issues/19
As Per https://docs.microsoft.com/en-us/power-bi/developer/power-bi-permissions we have the required permission for the App.
- Tenant level Read Write access.
- Power BI Service admin
- Capacity Admin
To call the API’s from the PowerShell or PowerQuery Custom connector doesn’t require MFA to be enabled ???
Our accounts configured with ADFS and Multi Auth. Calling the API’s is failing only for the admin API’s. Could you please help and suggest the right team to work this connector as its helpful in real-time with the telemetry data.
Note : we have checked with the owner of github and they have PIM enabled and everytime they will activate the role but here we don’t have the PIM License from the Azure portal but the Custom connector owner confirmed PIM is not requied.
7 Replies
Hi Anonymous ,
There is no requirement for the MFA using the Power BI REST API , you can refer to the link: https://datagulp.com/powerbi/power-bi-rest-api-how-to-get-authentication-token-with-powershell-cmdlets/.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft confirmed this as the bug, if we are using the MFA and could you please check and confirm once and what will be the ETA ??
Hi Anonymous ,
If you are using client id and client secret to connect which is a SPN Based autentication then PowerBI ADMIN API's won't work because that it a known limitation
Hello Jayendran ,
I'm trying with the UPN Account and its failing to login.. did Power BI admin rights are required to enable service principal in developer settings within the Power BI admin portal.Hi Anonymous ,
UPN should work, as i stated only the SPN won't work for the PowerBI Admin API's.
Seeing from your github issues latest comments, if you are using any MFA/ADFS(SSO) then it won't work. Please disable to MFA/SSO and try it again.
