IMPORTANT: Enabling Lineage requires the following permissions:
- Tenant.Read.All (Why BI Optimizer Requires Tenant.Read.All Permission?).
This article explains how to configure Microsoft Power BI Cloud Data Source for Lineage collection. This configuration is required for enabling BI Optimizer in Metric Insights.
Before proceeding, ensure that all prerequisites are met and that initial configuration has been completed based on your selected authentication type. Then, grant Tenant.Read.All permission in Azure Portal, return to Metric Insights to enable metadata collection and configure the Power BI Cloud Data Source, and sync metadata.
NOTE: We recommend configuring Log Analytics for Lineage to improve the precision of Lineage metadata collection. With Log Analytics enabled, Lineage returns more accurate data on columns and tables from which the Reports are derived. In case Log Analytics is disabled, the metadata returned from the Power BI available in Lineage may contain duplicates, such as extra tables and columns.
- See Configure Lineage Collection from Power BI and Log Analytics for instructions.
1. Grant Tenant.Read.All Permission
Access Azure App's Overview page > API Permissions > [Add a permission] > Delegated permissions > Tenant.Read.All
2. Enable Metadata Collection in Metric Insights
Access Admin > System > System Variables
- Enter
ENABLE_METADATA_COLLECTIONin the search field. - Click the gear icon.
- Assigned Value:
Y. - [Save], then [Commit Changes]
NOTE: See Setting System Variables for information on System Variables configuration.
3. Configure Power BI Cloud Data Source in Metric Insights
3.1. Create a Microsoft Power BI Cloud Data Source
See Establish Connectivity to Microsoft Power BI Cloud for instructions on creating a new Microsoft Power BI Cloud Data Source.
3.2. Configure Auth Parameters
Proceed with the Data Source parameters configuration based on the selected Auth Type:
Service Principal
- Auth Type: Service Principal
- Application ID: Enter the Application ID of the previously configured Azure App.
- Client Secret: Enter the Client Secret of the previously configured Azure App.
- Server: https://app.powerbi.com
- Directory (tenant) Id: Enter Directory (tenant) Id of the previously configured Azure App
- To find this value, open the Azure App > Overview tab
Password
- Auth Type: Password
- Application ID: Enter the Application ID of the previously configured Azure App.
- Server: https://app.powerbi.com
- Username, Plugin Password: Enter the credentials of a Fabric Administrator user
OAuth
- Auth Type: OAuth
- Application ID: Enter the Application ID of the previously configured Azure App.
- Server: https://app.powerbi.com
- Directory (tenant) Id: Enter Directory (tenant) Id of the previously configured Azure App
- To find this value, open the Azure App > Overview tab
- [Get Token], enter credentials of a Fabric Administrator in the pop-up window
3.3. Configure Other Data Source Parameters
See parameter configuration details specific to your MI version:
v7.1.1
| Parameter Name | Value | |
| 1 | Scope: Collect as admin | true |
| 2 | Scope: Types to collect | DASHBOARD, TILE, SEMANTIC_MODEL, TABLE, REPORT |
| 3 | Scope: Workspace Filter | Use this filter to narrow down the search
output |
| 4 | OleDB: Collect Data from OleDB | true |
| 5 | OleDB: Use old table ID | false |
| 6 | Power BI Premium: Collect media using API | true |
Prior to v7.1.1
| Parameter Name | Value | |
|---|---|---|
| 1 | Collect objects as admin | true |
| 2 | Power BI Premium: Collect media using API | true |
| 3 | Object types to collect | DASHBOARD, TILE, SEMANTIC_MODEL, TABLE, REPORT |
| 4 | Old table ID | false |
| 5 | OleDB Data | true |
| 6 | Workspace Filter | Use this filter to narrow down the search output |
3.4. Configure Object List Refresh
3.4.1. Manually Refresh Object List
Access Source Objects tab
- [Refresh list]
- Once the list is refreshed, the Log Analytics object is displayed.
3.4.2. Add Object List Refresh Trigger
Adding an Object List Refresh Trigger allows to automatically refresh the Object List at the configured time interval.
- Generate Object List: automatically.
- Object List Refresh Trigger: Select a daily Trigger.
- See What is Data Collection Trigger? for details.
3.5. Sync Metadata
Access Metadata tab
- [Sync Metadata]