Documentation Index
Fetch the complete documentation index at: https://docs.trydatawise.com/llms.txt
Use this file to discover all available pages before exploring further.
Connect Datawise to Power BI to surface Power BI reports and datasets as downstream assets in your lineage graph.
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
| Field | Description |
|---|
| Tenant ID | Your Azure AD tenant ID. Found in Azure Portal under Azure Active Directory > Overview. |
| Client ID | The Application (client) ID of your Azure AD app registration. |
| Client Secret | The client secret value you copied from Azure AD. |
| Name | A display name for this connector in Datawise. |
Optional Fields
| Field | Description |
|---|
| Workspace | Restrict ingestion to a specific Power BI workspace. Leave blank to ingest all accessible workspaces. |
| Allow Patterns | Only ingest workspaces matching the specified pattern. |
Settings
| Setting | Default | Description |
|---|
| Extract Ownership | Off | Pull report and dataset owner information into Datawise. |
| Extract Endorsements to Tags | Off | Pull Power BI endorsement labels (Certified, Promoted) as tags on assets. |
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.
