Power BI Integration Requirements

The following are the prerequisites necessary for IBM Manta Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.

Manta Data Lineage supports these two extraction modes with different approaches to extracting report definitions: Azure and on-premises. Power BI Service is hosted in Azure, and it provides data lineage information more readily. Power BI Server requires the manual extraction of the Power Query information stored within the PBIX files. Each mode has different requirements and limitations as described below.

The extraction via Manta Flow Agent is supported as of version R42.2. See Manta Flow Agent Configuration for Extraction for details.

Manta Data Lineage relies on Java default truststore (usually known as cacerts) to validate certificates for PowerBI API URLs. This is generally fine as the Java default truststore contains the required certificates. However, some organizations choose to modify (empty) the default truststore and in such cases the certificates for both api.powerbi.com and login.microsoftonline.com need to be imported into Java default truststore (note that this may not survive update of Java).

Azure Extraction Mode

Azure extraction mode allows automatic extraction using a REST API to connect to Power BI Pro/Premium through Azure Active Directory.

The recommended way to set up a Power BI Azure scan is documented in Power BI Azure Setup.

Limitations

Manta Data Lineage uses Power BI metadata scanning to obtain metadata needed for creating the correct lineage. The main limitation of Power BI metadata scanning is that it doesn’t work for datasets that haven't been refreshed or republished (as documented in Metadata scanning overview). This means that Manta Data Lineage cannot properly analyze reports that haven’t been refreshed or republished (since enabling the metadata scanning in Power BI settings).

The best way to mitigate this limitation is to refresh datasets for all reports that you want Manta Data Lineage to analyze. The refresh can be a one-time event (after enabling the metadata scanning) or a scheduled periodical event. The official guide for configuring scheduled refresh (Configure scheduled refresh) describes how to establish periodical refreshes.

Local Extraction Mode

Local extraction mode allows automatic extraction using a REST API to connect to a Power BI Report Server.

The recommended way to set up a Power BI Local scan is documented in Power BI Local Setup.

Limitations

When you use the local extraction mode, it’s necessary to manually input the Power Query script for each scanned report. See How to Manually Insert Power Query Script for more details.

Supported Features

This is a list of Power BI features that Manta Data Lineage supports. There may be features that aren’t explicitly named but are included in the named items, as this list aims to be a high-level overview. Other than that, features that are not listed are primarily considered not supported.

*These features are only supported in the Azure extraction mode when access to the Scanner API is set up correctly.

Known Unsupported Features

IBM Manta Data Lineage does not support the following Power BI features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.