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
- Username and Password for Azure
Choose the method for creating a connection based on where you are in the platform
In a project
Click Assets > New asset > 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.
Where you can use this connection
You can use the Microsoft Power BI (Azure) connection in the following workspaces and tools:
Catalogs
- Platform assets catalog
Data lineage
- Metadata import (lineage) (IBM Knowledge Catalog and 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
Parent topic: Supported connections