Set up Service Account for PowerBI
Last updated
Last updated
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.
Go to the Azure Portal. Navigate to Azure Entra ID
Click "+ Add" > "App registration"
Enter app registration details. name: Smaply Power Bi. connector Supported account type: Accounts in this organizational directory only (Single tenant no need to set a redirect URI And click "Register"
Within your app, navigate to Manage > API Permissions > Add a permission.
Choose Power BI Service.
Under Application permissions, add:
Tenant.Read.All
Click Grant admin consent for {Your Tenant Name}.
Within your app, navigate to Certificates & Secrets.
Under Client Secrets, click + New client secret. description: Power Bi Smaply connector client secret expiry: [e.g. 12 months]
Copy the generated Client Secret value, you will need it later.
Create a new security group ("New Group"). type: Security name: smaply-powerbi description: Smaply PowerBI Connector security group members: assign the Service Principal (Application). E.g. "Smaply Power BI Connector" from step 1
Open Service Principal can use Fabric APIs (under tenant settings)
Enable Service Principal access. Apply to: Specific security groups: type in the security group name from step4; e.g. smaply-powerbi Apply
In Power BI, do the following for all of the Workspace that Smaply should have access to:
Make sure you have given the service account member access to the workspace.
Wait 30 to 60 minutes for the changes to propagate.
Once all configurations are in place, set up the integration in Smaply using from the service principal (Entra app). You'll need:
Tenant ID
Client ID
In Smaply Account settings > Integrations > Power BI, add the details
Once validated, you will be able to select any workspace that you set up in step6
Navigate to .
Go to the .
Assign the Security Group (created in Step 4) to a workspace. Note: your personal workspaces won't support this.
Client Secret (from step3)
Now you're ready to create your first metric with Power BI 🚀.