> ## 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.

# Power BI

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

1. In the Azure Portal, go to **Azure Active Directory > App registrations**.
2. Click **New registration**. Give it a name (e.g., `datawise-powerbi`) and click **Register**.
3. Note the **Application (client) ID** and the **Directory (tenant) ID**.
4. Go to **Certificates & secrets > Client secrets** and click **New client secret**.
5. Copy the secret value immediately. It is only shown once.
6. 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.