Power BI Admin Rest API's

[Anonymous]

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.

1. Tenant level Read Write access.
2. Power BI Service admin
3. 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.

[v-xicai]

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.

[Anonymous]

@v-xicai, 

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 ??

https://github.com/microsoft/powerbi-powershell/issues/135

[Jayendran]

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

[Anonymous]

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.

[Jayendran]

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.

[Anonymous]

Hi @Jayendran , 

I need offical confirmation so that I can check with our security team for exception and try it. 
To call the admin API with client ID and Secret ID doesn't any require MFA/SSO ??
I tried checking in the many documents but no where i found that.. 

[Jayendran]

Hi @Anonymous ,

I'm not sure what is the autentication that custom connector is using, I assume it is using a password grant in such case the MFA will fails, you can see this releated threads

Reg your other query,

For SPN you don't have to worry about the MFA/SSO.However PowerBI Admin API's wont support in SPN as of now. So this is a dead end for you.