​
Overview

Our Power BI integration can help you visualize column-level lineage dependencies between warehouse tables and Power BI entities using Data Explorer. Datafold supports the following Power BI entity types:
  • Tables (with Columns)
  • Reports (with Fields)
  • Dashboards

​
Set up the integration

1

Open Microsoft 365 admin center

Navigate to Microsoft 365 admin center -> 👤 Active users and choose the user that Datafold will authenticate under.
As highlighted in the screenshot above, this user should have the Power Platform Administrator role assigned to it.
2

If the role is missing, assign it

Click Manage roles, enable the Power Platform Administrator role, and save changes.
3

Configure Power BI API

Navigate to Power BI Admin Portal and enable the following two settings:
  • Enhance admin APIs responses with detailed metadata
  • Enhance admin APIs responses with DAX and mashup expressions
4

Create Power BI integration in Datafold

In the Datafold app, navigate to Settings -> BI & Data Apps, and click + Add new integration. Choose Power BI from the list.
5

Fill in the name for your new integration

…and then Save.
On clicking Save, the system will redirect you to Power BI.
6

Sign in to Power BI

…if not already signed in.
7

Grant permissions to Datafold

Allow the Datafold integration to use Power BI. Depending on the roles configured for your user in the Admin center, you may require a confirmation from a Global Administrator. Follow the steps in the wizard.
8

Integration is ready

You will be redirected back to Datafold and see a message that Power BI is successfully connected.
9

Power BI integration needs some time to sync

You can check out Jobs -> BI & Data Apps for the status of the sync job.
See Tracking Jobs for more details.
10

Power BI entities are now searchable

When the sync is complete, you will see Power BI entities in Data Explorer.
11

Lineage is now available

​
Need help?

If you have any questions about our Power BI integration, please reach out to our team via Slack, in-app chat, or email us at support@datafold.com.