Set up Service Account for PowerBI

Setting up a Service Account for Power BI in Azure Entra requires multiple steps, including creating an app, assigning permissions, and configuring access. Follow this guide to complete the setup.

---

Step 1: Register an App in Azure Entra

1. Go to Azure Portal App Registration.

2. Click New Registration.

3. Set Supported Account Types to:

   • Accounts in this organizational directory only (Single tenant).

Step 2: Assign API Permissions

1. Navigate to API Permissions > Add a permission.

2. Choose Power BI Services.

3. Under Application permissions, add:

   • Tenant.Read.All

   • Tenant.ReadWrite.All

4. Click Grant admin consent for {Your Tenant Name}.

Step 3: Create a Client Secret

1. Go to Certificates & Secrets.

2. Under Client Secrets, click + New client secret.

3. Save the generated Client Secret securely.

Step 4: Create a Security Group & Assign the Service Principal

1. Navigate to Azure Groups Management.

2. Create a new security group.

3. Assign the Service Principal (Application) as a member of this group.

Step 5: Configure Power BI Admin Settings

1. Go to the Power BI Admin Portal.

2. Enable Service Principal access.

Step 6: Create a New Workspace & Assign Access

1. In Power BI, create a new Workspace.

2. Assign the Security Group (created in Step 4) to this workspace.

   
3. Wait 30 to 60 minutes for the changes to propagate.

Step 7: Configure Power BI in Smaply

Once all configurations are in place, set up the integration in Smaply using

• Tenant ID

• Client ID

• Client Secret