Microsoft Power BI (Azure) connection

To access your data in Power BI Pro or Premium, 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 Azure describes the extraction mode that is used to extract business intelligence report definitions. Automatic extraction connects to Power BI Pro or Power BI Premium through the Azure Active Directory.

Prerequisite

Create an application in the Microsoft Azure portal.

Create a connection to Microsoft Power BI (Azure)

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

  • Directory ID: Azure Active Directory tenant ID
  • Application ID: Azure application ID
  • Client secret: Azure client secret
  • Optional: Username and Password for Azure

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. See Adding platform connections.

Next step: Add 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 (Azure) connection cannot be created in a FIPS environment.

Microsoft Power BI (Azure) 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.

Learn more

Importing metadata

Related connection: Microsoft Power BI Desktop connection

Parent topic: Supported connections