Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 O...
Need Help
Jayendran's avatar
Jayendran
Solution Sage
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Jayendran
    Solution Sage
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Jayendran
        Solution Sage
        6 years ago

        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.