Overview

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:

  • Datasets
  • Dashboards
  • Reports

To document your Power BI assets in Lineage, Monte Carlo:

  1. Scans all Power BI Workspaces that are available to the Service Principal you create for Monte Carlo.
  2. Fetches the Datasets, Dashboards, and Reports available from each Workspace.
  3. For each Dashboard Tile (on a Dashboard) and Report, parse the Dataset used.
  4. For each Dataset, parse the Tables or SQL Query used. Both Direct Data Sources and Native Queries and are supported.

Caveats

  • 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:

  1. 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.
  2. 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]

To create a Service Principal:

  1. Sign into your Microsoft Azure account
  2. Create an Azure AD app
  3. Create an Azure AD security group
  4. Enable the Power BI service admin settings
  5. Add the service principal to your workspace (note this step must be done for every workspace!)

More detailed documentation on how to create a service principal can be found here.

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:

  1. Select the "Power BI" from the New Integration button under Business Intelligence connections

  2. 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.

29642964 17501750
  1. Click connect and confirm that no connection errors exist.