Power BI (beta)
This capability is in beta
Certain limitations in functionality may exist.
Monte Carlo collects various assets from Power BI in order to document downstream lineage from your data storage. At a high-level, Monte Carlo collects:
To document your Power BI assets in Lineage, Monte Carlo:
- Scans all Power BI Workspaces that are available to the Service Principal you create for Monte Carlo.
- Fetches the Datasets, Dashboards, and Reports available from each Workspace.
- For each Dashboard Tile (on a Dashboard) and Report, parse the Dataset used.
- For each Dataset, parse the Tables or SQL Query used. Both Direct Data Sources and Native Queries and are supported.
- Only tables from Google BigQuery, Snowflake, and Databricks are supported as of now. Please reach out if you are using tables from another data source and we can get this configured.
- Dataflows are not yet supported. Please reach out if you are using Dataflows and would be interested in support.
Connecting Power BI
This guide explains how to create a user for Monte Carlo on Power BI.
Service principal credentials required
To complete this guide, you will need a Service Principal's credentials.
To review all steps necessary to integrate a BI tool with Monte Carlo, please see here.
1. Creating a Monte Carlo User on Power BI
There are two access options with Power BI:
- Service Principal (Recommended): With this option, Monte Carlo requires the Service Principal's client ID, client secret and tenant id to access the appropriate Power BI APIs.
- Master User (Classic workspaces only): With this option, Monte Carlo requires a Master User's credentials to access the Power BI APIs.
Option 1: Creating a Service Principal [Recommended]
Detailed documentation on how to create a service principal can be found: Power BI - Credential Creation Process.
It is recommended to follow the detailed instructions above. In summary, to create a Service Principal:
- Sign into your Microsoft Azure account
- Create an Azure AD app
- Create an Azure AD security group
- Enable the Power BI service admin settings
- Add the service principal to your workspace (note this step must be done for every workspace!)
Option 2: Creating a Master User
MS Azure customers with Classic Workspaces can follow the steps outlined here to generate a Master User with the appropriate permissions.
2. Configure a Power BI Integration in Monte Carlo
To configure a new Power BI integration, visit the "Integrations" tab within "Settings" in your Monte Carlo account and follow these steps:
Select the "Power BI" from the New Integration button under Business Intelligence connections
Enter the appropriate Service Principal credentials (or Master User credentials)
Note: You can find your tenant ID in the Overview tab within your Azure account portal.
- Click connect and confirm that no connection errors exist.
Updated 23 days ago