Technical lineage for Power BI

When you ingest Power BI metadata in Data Catalog, Collibra Data Lineage automatically creates a technical lineage for assets of the following types:

  • Power BI Report
  • Power BI Table
  • Power BI Column

To view the technical lineage, go to the asset page of any asset of these types, and then click the Technical Lineage tab.

Note If you ingest Power BI for the first time or if you change your geolocation or cloud provider, you have to restart the DGC service before you can see your technical lineage.

Technical lineage graph

The technical lineage graph shows relations of the type "Data Element targets / sources Data Element" between BI assets and other data objects in the data flow, for example Column assets or Power BI Column assets. These relations are created during the Power BI ingestion process as a result of automatic stitching.

Example

The following technical lineage shows the relation of the type "Data Element targets / sources Data Element" between the Column asset LISTPRICE and the Power BI Column asset ListPrice.

Sources tab page

The Sources tab page shows the transformation details that were analyzed and processed on the Collibra Data Lineage service instances and the results of this analysis. The success rate of the analysis indicates how complete the technical lineage is.

Important The Collibra Data Lineage server can process most, but not all, complex Power BI metadata. This means that the success rate of a Power BI ingestion can be very high, but almost never 100%.

Example

The following image shows that you have created a technical lineage for four data sources. Power BI has a success rate of 83%. When you use the transformation logs to investigate the errors, you see that the Collibra Data Lineage service instance couldn't process some elements of the Power BI metadata, for example because they are not supported or there is an issue in the configuration file or the Power BI setup.