Power BI

Overview

Datadog’s Power BI integration helps data teams make changes to their data platform without breaking dashboards, and identify unused reports and dashboards to remove. When Datadog connects, it:

  • Pulls metadata from your Power BI account like datasets, reports, and dashboards.
  • Automatically generates lineage between warehouse tables with downstream datasets, reports, and dashboards.

Connect Power BI

Create an app registration and security group

App registration

  1. Sign into Microsoft Azure.
  2. Search for App registrations.
  3. Click New registration.
  4. Fill in the required fields and register an application for Datadog.
  5. Copy the Application (client) ID somewhere safe.
  6. Go to Certificates & secrets in sidebar and click New client secret.
  7. Add a secret for Datadog.
  8. Copy the secret value somewhere safe.

Security group

  1. Search for Azure Active Directory.
  2. Go to Groups in the sidebar and click New group.
  3. Create a group for the app registration.
  4. Click into the newly created group. You may need to refresh the page for it to show up.
  5. Go to Members in the sidebar and click Add members.
  6. Find the app registration created earlier and add it as a member.

Grant access in Power BI

Enable API and admin API access for security group in Power BI Admin

  1. Go to the Power BI Admin portal.
  2. In Tenant settings, go to Developer settings.
  3. Enable Allow service principals to use Power BI APIs for your security group.
  4. In Tenant settings, find Admin API settings.
  5. Enable the following for your security group:
    • Allow service principals to use read-only admin APIs
    • Enhance admin APIs responses with detailed metadata
    • Enhance admin APIs responses with DAX and mashup expressions

Grant access to workspaces

From the Power BI Admin portal:

  1. From the sidebar, click Workspaces to open the Workspaces pane.
  2. For each workspace you want Datadog to have access to, open the Access panel by clicking the three vertical dots and selecting Workspace access.

Add the Power BI integration

  1. Navigate to the Power BI integration tile and enter your tenant ID, and the client ID and secret from earlier.
  2. After you’ve entered these credentials, click Save.

What’s next

When your Power BI account is successfully connected, Datadog syncs and automatically derives lineage from warehouse tables/columns to Power BI datasets, reports, and dashboards.

Initial syncs may take up to several hours depending on the size of your Power BI deployment.

After syncing, you can explore your Power BI assets and their upstream dependencies in the Data Observability Explorer.

Further reading

Additional helpful documentation, links, and articles:

Learn about Data ObservabilityDOCUMENTATION more more