Use this connector to have Foundational scan and determine lineage and downstream impact for Power BI.
This setup should take about 15 minutes.
Permissions: You need to be an Azure admin for some parts of this setup.
Configuring Power BI Connector
In order to provide Foundational access to Power BI, please follow the steps below:
1. Create Azure Application
Sign in to the Azure Portal at https://portal.azure.com
Select
Microsoft Entra ID
Select
App registrations
Select
New registration
In the new window, enter a name for the application, e.g.,
powerbi-foundational-connector
. Keep the other options with the default selection, and click Register to complete
The Azure portal will now open the
powerbi-app-connector
window. Write down the value ofApplication (client) ID
and the value ofDirectory (tenant) ID
. You will need both of these values later in the Foundational connector configuration screenSelect
Add a certificate or secret
to generate a secret for the application
Click on
New client secret
Fill in the description and set an expiration date
Write down the
Secret ID
andValue
2. Create a new Azure Active Directory security group
Sign in to https://portal.azure.com
Go to
Microsoft Entra ID
Select Groups
Click on
New group
Set Group Type to
Security
, and provide a group name, e.g.,power-bi-foundational-connector-security-group
Now, add a member to the group by clicking on
No members selected
Add the
power-bi-foundational-connector
application that we created in the previous step as a member of this group
3. Assign Permissions to the Security Group
Sign in to https://app.powerbi.com/
Click the gear icon to open Settings, and then select
Admin portal
In
Admin portal
, selectTenant settings
In
Tenant settings
, go to theAdmin API settings
section:Enable
Service principals can access read-only admin APIs
, and addpower-bi-foundational-connector-security-group
to theSpecific security groups
Enable also these two options:
Enhance admin APIs responses with detailed metadata
Enhance admin APIs responses with DAX and mashup expressions
(you need the DAX configuration, as some of the PowerBI queries might be using DAX and mashup expressions for reading data)
In
Tenant settings
, selectDeveloper settings
4. Add the Security Group to Relevant Workspaces
Sign in to https://app.powerbi.com/
Go to the workspace you want Foundational to access
Select
Manage Access
Add
power-bi-foundational-connector-security-group
to the list of users with access, with aViewer
role