How to get lineage from Power BI into Microsoft Purview

This article elaborates on the data lineage aspects of Power BI source in Microsoft Purview. The prerequisite to see data lineage in Microsoft Purview for Power BI is to scan your Power BI.

Important

Currently, supported sources for Power BI Lineage are:

  • Azure SQL
  • Azure Storage
  • Azure Data Lake Store Gen1
  • Azure Data Lake Store Gen2

Common scenarios

  1. After the Power BI source is scanned, data consumers can perform root cause analysis of a report or dashboard from Microsoft Purview. For any data discrepancy in a report, users can easily identify the upstream datasets and contact their owners if necessary.

  2. Data producers can see the downstream reports or dashboards consuming their dataset. Before making any changes to their datasets, the data owners can make informed decisions.

  3. Users can search by name, endorsement status, sensitivity label, owner, description, and other business facets to return the relevant Power BI artifacts.

Power BI artifacts in Microsoft Purview

Once the scan of your Power BI is complete, following Power BI artifacts will be inventoried in Microsoft Purview

  • Capacity
  • Workspaces
  • Dataflow
  • Dataset
  • Report
  • Dashboard

The workspace artifacts will show lineage of Dataflow -> Dataset -> Report -> Dashboard

Screenshot showing how Overview tab is rendered for Power BI assets.

Note

  • Column lineage and transformations inside of PowerBI Datasets is currently not supported
  • Limited information is currently shown for the Data sources from which the PowerBI Dataflow or PowerBI Dataset is created. E.g.: For SQL server source of a PowerBI datasets only server name is captured.

Lineage of Power BI artifacts in Microsoft Purview

Users can search for the Power BI artifact by name, description, or other details to see relevant results. Under the asset overview & properties tab the basic details such as description, classification and other information are shown. Under the lineage tab, asset relationships are shown with the upstream and downstream dependencies.

Screenshot showing how lineage is rendered for Power BI.

Next steps