Forum Discussion

icassiem's avatar
icassiem
Post Prodigy
2 years ago
Solved

PowerBI API Rest Service Principal Authentication

Good day,   I have downloaded the below template from the forum: Connect with Power BI to the Power BI REST API with a Service Principal – PBI Guy (pbi-guy.com)   I can manually conmnnect to the ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi icassiem ,

     

    1.Ensure that your Service Principal has been granted the necessary permissions within the Azure portal and that it has been added as a workspace Member or Admin in Power BI.

    Refer: Automate Power BI Premium workspace and semantic model tasks with service principals - Power BI | Microsoft Learn

    2. Double-check that the Service Principal has been granted the correct API permissions in Azure. Specifically, look for Power BI Service permissions like Dataset.Read.All, Dashboard.Read.All, etc., depending on your use case.

    3. When connecting to the Power BI REST API, ensure that you're using the correct authentication details. This includes the Application (client) ID, Directory (tenant) ID, and the client secret.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi icassiem ,

 

1.Ensure that your Service Principal has been granted the necessary permissions within the Azure portal and that it has been added as a workspace Member or Admin in Power BI.

Refer: Automate Power BI Premium workspace and semantic model tasks with service principals - Power BI | Microsoft Learn

2. Double-check that the Service Principal has been granted the correct API permissions in Azure. Specifically, look for Power BI Service permissions like Dataset.Read.All, Dashboard.Read.All, etc., depending on your use case.

3. When connecting to the Power BI REST API, ensure that you're using the correct authentication details. This includes the Application (client) ID, Directory (tenant) ID, and the client secret.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

  • icassiem's avatar
    icassiem
    Post Prodigy
    2 years ago

    Thank You very much, i dont have Azure Admin access and only PBI Admin Access, i have forwarded the above to my Azure Admin

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi icassiem ,

       

      Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

       

      Best Regards,

      Neeko Tang

      If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

      • icassiem's avatar
        icassiem
        Post Prodigy
        2 years ago

        Hi Anonymous 

        Thank You for Helping, my azure admin responded it was too complicated and not possible to achieve. Without Azure Admin, there's nothing i can do.

        Regards