Prerequisites
- An Azure Active Directory (Azure AD) application (service principal) with access to your Power BI workspace.
- The Tenant ID, Client ID, and Client Secret for the Azure AD app.
- Power BI service configured to allow service principal access. Enable this under Admin Portal > Tenant Settings > Developer settings > Allow service principals to use Power BI APIs.
Create an Azure AD App Registration
- In the Azure Portal, go to Azure Active Directory > App registrations.
- Click New registration. Give it a name (e.g.,
datawise-powerbi) and click Register. - Note the Application (client) ID and the Directory (tenant) ID.
- Go to Certificates & secrets > Client secrets and click New client secret.
- Copy the secret value immediately. It is only shown once.
- In Power BI, add the service principal to your workspace. Go to the workspace, click Access, and add the app with the Viewer or Member role.
Connection Setup
Go to Connectors, click Add Connector, and select Power BI.Required Fields
Optional Fields
Settings
After Connecting
- Power BI reports and datasets appear in Data Assets as downstream assets.
- The Lineage view shows Power BI reports connected to the warehouse tables and dbt models they depend on.
- When Schema Radar detects a breaking schema change, impacted Power BI reports appear in the downstream impact view.