The Microsoft Power BI connector extracts metadata from a Power BI service and establishes lineage within assets.
For the Power BI Report Server:
- The connector has been tested with the Power BI Report Server, product version 15.0.1102.675.
- Supports basic authentication with HTTPS and NTLM.
- Authentication will work if the URL uses HTTPS and the authentication type is Basic, but only if the authentication is sent through an encrypted header. This is the recommended setup.
- Authentication will not work if the URL uses HTTPS and the authentication type is NTLM, because NTLM does not support a secured call.
- Authentication will work without a proxy if the URL uses HTTP and the authentication type is NTLM, but will not work with a proxy. The connection must be direct to the Power BI server.
For Power BI Azure Hosted:
- The harvester is tested with Power BI REST API version V1.0.
- Client secret based authorization is supported.
- Certificate based authorization is not supported.
- Azure hosted Power BI supports "Resource Owner Password Credentials" authentication: The Microsoft identity platform includes support for the Resource Owner Password Credentials (ROPC) grant in OAuth 2.0. This grant enables an application to authenticate users by directly handling their username and password.
For all setups, the Power BI Connector supports:
- The lineage between "Field used in reports" and "Actual Table Columns".
- Establishing connections between reports and fields used to create those reports.
- Establishing connections between reports and the data source used for the reports.
- Exhaustive metadata for each asset type.
- Links to the database table columns, if the source is Microsoft SQL Server, Oracle, teradata or Big Query.