Forum Discussion

Koteswara's avatar
Koteswara
New Member
1 year ago
Solved

Power BI workspace creation using API

Hi Team, I am using API (https:// api. powerbi. com/ v1.0/ myorg/ groups) to create a Power BI workspace using java code. For authenticationpurpose I am using Azure Service Principle.  I would like...
Need Help
  • Koteswara's avatar
    Koteswara
    1 year ago

    HI jaineshp 
    We have achieved the target.
    Please note that Power BI roles renamed to Fabric.
    https://powerbi.microsoft.com/en-us/blog/power-bi-administrator-role-will-be-renamed-to-fabric-administrator/
    Steps performed is
    1. Workload identity configuration in AKS cluster

    2. Assign Fabric Administrator role

     

    3. Tenant Setting Location

    The setting "Allow service principals to use Power BI APIs" is found at:

    • Power BI Admin Portal → Tenant settings → Developer settings
    • Look for "Allow service principals to use Power BI APIs"

    4. Add UAMI to capacity group in azure

    Thank you all..

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi Koteswara ,

 

Using a User Assigned Managed Identity (UAMI) is fully supported for calling the Power BI REST API from AKS. Here’s the streamlined approach:


1. Scope: Stick with https://analysis.windows.net/powerbi/api/.default as your scope when acquiring tokens for Power BI REST API. This is the same as with a Service Principal.

 

2. Permissions/Roles: Assign your UAMI either the Power BI Service Admin role (for full API control) or just Admin/Member rights on specific workspaces, depending on what your automation needs. In Power BI Admin Portal, make sure “Allow service principals to use Power BI APIs” is enabled—this is required for managed identities too.

 

3. AKS Setup: If your AKS pod is already using the UAMI for Azure Storage, you’re set. In your Java code, use the Azure SDK’s DefaultAzureCredential to authenticate—no secrets or SP credentials needed.


You don’t have to change your scope or approach when switching from SP to Managed Identity. As long as the right roles are in place and workload identity is configured, UAMI works great for Power BI API automation in AKS.