Microsoft Power BI (Azure) connection

To access your data in Power BI Pro or Premium, create a connection asset for it first.

Microsoft Power BI is a business analytics solution that includes products and services for business intelligence (BI) reporting and data visualization. The Azure qualifier 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
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 > Data access tools > Connection. 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 assets from the connection

To add assets and lineage information to a catalog, run a metadata import.

Where you can use this connection

Use the Microsoft Power BI (Azure) connection in these workspaces and tools:

Projects

Metadata import (Watson Knowledge Catalog). For information about the supported product versions and other prerequisites when connections are based on MANTA Automated Data Lineage for IBM Cloud Pak for Data scanners, see the Lineage Scanner Configuration section in the MANTA Automated Data Lineage on IBM Cloud Pak for Data Installation and Usage Manual. This documentation is available at https://www.ibm.com/support/pages/node/6597457.

For metadata import (lineage), advanced metadata import must be enabled and a MANTA Automated Data Lineage license key must be installed. See Installing Watson Knowledge Catalog, Installing MANTA Automated Data Lineage, and Enabling lineage import.

Catalogs

Platform assets catalog

Federal Information Processing Standards (FIPS) compliance

You can't create the Microsoft Power BI (Azure) connection in a FIPS environment.

Microsoft Power BI (Azure) setup

For more 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.

Restrictions

When you create or update a connection, connection testing 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 (Local) connection

Parent topic: Supported connections