Power BI Integration

Connect Power BI to Metaustral and automatically catalog your workspaces, datasets, reports, and dashboards.

Metaustral connects to the Power BI REST API using an Azure AD Service Principal. Once connected, it discovers datasets (with their tables and columns) and reports as catalog assets.

Prerequisites

A Power BI Pro or Premium workspace.
An Azure AD App Registration (Service Principal) with the Dataset.Read.All and Report.Read.All permissions in the Power BI service.
The Service Principal must be enabled in the Power BI Admin portal under Admin → Tenant settings → Developer settings → Allow service principals to use Power BI APIs.
Starter, Pro, or Enterprise plan.

How to connect

Create an Azure AD App Registration

In the Azure portal, go to Azure Active Directory → App registrations → New registration. Note the Application (client) ID and Directory (tenant) ID. Create a client secret under Certificates & secrets and copy the value immediately.

Grant Power BI API permissions

In the App Registration, go to API permissions → Add a permission → Power BI Service and add Dataset.Read.All and Report.Read.All. Then grant admin consent.

Open Integrations and click + New connection

Select Power BI as the type and enter the Tenant ID, Client ID, and Client Secret. Optionally add a Workspace ID to limit discovery to a single workspace.

Save and import metadata

Go to Import → From a connection, select this connection, and click Confirm import. Metaustral creates DASHBOARD and REPORT assets from your Power BI workspaces.

Connection fields

Field	Where to find it
Tenant ID	Azure AD → App registration → Overview → Directory (tenant) ID.
Client ID	Azure AD → App registration → Overview → Application (client) ID.
Client Secret	Azure AD → App registration → Certificates & secrets → Client secrets. Copy immediately after creation.
Workspace ID (optional)	Power BI service URL when browsing a workspace: `app.powerbi.com/groups/<workspace-id>`.