Power BI
Power BI is a platform for unified, scalable self-service and enterprise business intelligence (BI).
Prerequisites for Integrating with Power BI
To connect Validio to your Power BI instance,
- Register a Microsoft Entra application for Validio. You will need the Application (client) ID, client secret key, and Directory (tenant) ID from this application. This application is the service account you will reference to create a PowerBI credential in Validio. For more information, refer to Microsoft documentation.
- Create a Microsoft Entra security group and add your registered application as a member.
- In your Power BI Admin portal, ensure that you have permissions to access and read data from the relevant workspaces. You should have the following settings:
- In Tenant settings, enable “Service principals can use Fabric APIs” and apply it to the relevant security groups.
- In Workspaces, add the Microsoft Entra application as a Member to the relevant workspace.
Add a Power BI Credential
To add a Power BI credential in Validio,
- Navigate to Credentials, and click + New Credential.
- Under Credential Type, select Power BI Credential.
- Fill in the configuration parameters for the credential type. For more information, see Power BI Credential Parameters.
- Click Create.
Validio will perform a validation step to ensure that the Power BI account can be successfully accessed. If validation passes, Validio will automatically start fetching data and you will be able to view Power BI assets and their relationships in the Catalog (if selected) and Lineage pages. If validation fails, check that you provided the correct parameter values.
Power BI Credential Parameters
Field | Description |
---|---|
Credential Type | Power BI Credential |
Namespace | Defines where the credential will be created. |
Name | The identifier used to reference the credential within Validio. |
Client ID | The client ID of your Azure registered application. |
Client Secret | The client secret of your Azure registered application. |
Tenant ID | The tenant ID of your Azure registered application. |
Use for Catalog | Check to include Power BI assets in the catalog. |
View Power BI Assets in Catalog
To view the Power BI assets in Catalog, navigate to Catalog and select the BI Tools tab.
The Power BI assets are listed and organized by Name, Type, Credential, Date, and Tags. To view more information about each asset, click on the row to open the details panel.
Note:
You do not have the option to convert BI Tool assets to a source.
For more information, see About Data Catalog.
View Power BI Assets in Lineage
To view the Power BI assets in Lineage, navigate to Lineage. You can also open Lineage directly for a Power BI asset by opening its details panel and clicking View in Lineage.
For more information, see About Data Lineage.
Updated about 2 months ago