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