Microsoft Power BI Desktop connection

To access your data in Power BI Report Server, create a connection asset for it.

Microsoft Power BI is a business analytics solution that includes products and services for business intelligence (BI) reporting and data visualization. The qualifier local describes the extraction mode that is used to extract business intelligence report definitions. Local extraction connects to Power BI Report Server.

Create a connection to Microsoft Power BI Desktop

To create the connection asset, you need the following connection details:

  • Local server address: Hostname or IP address of the Power BI server.
  • Local server port: The default value is 80.
  • Local server folder: The folder on the server where reports are stored, for example, Reports.
  • Username and Password to the Power BI server.

To use the SSL security protocol, select Port is SSL-enabled. The certificate must be in the MANTA Automated Data Lineage truststore.

For Credentials, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.

In the Platform assets catalog
Click New connection. For more information, see Adding platform connections.

Next step: Add data assets from the connection

Run metadata import to add assets and lineage information to a catalog.

Federal Information Processing Standards (FIPS) compliance

The Microsoft Power BI Desktop connection cannot be created in a FIPS environment.

Microsoft Power BI Desktop setup

For information about the supported product version and other prerequisites, see the Power BI topic in the Lineage Scanner Configuration section in the MANTA Automated Data Lineage for IBM Cloud Pak for Data Installation and Usage Manual. The MANTA Automated Data Lineage for IBM Cloud Pak for Data documentation is available at https://www.ibm.com/support/pages/node/6597457 and IBM Manta Data Lineage.

Restrictions

Connection testing when you create or update the connection doesn't work for this connection. A connection is validated when you set up a metadata import that uses the connection.

Related connection: Microsoft Power BI (Azure) connection

Parent topic: Supported connections