Microsoft | Power BI

Power BI is a robust business analytics tool renowned for its intuitive interface and powerful data visualization capabilities. It empowers users to transform raw data into actionable insights, facilitating informed decision-making across organizations. With its comprehensive suite of features and seamless integration with various data sources, Power BI enables users to analyze data in real-time, driving enhanced business performance and agility.

Power BI Integration with ADOC

ADOC extends its data reliability capabilities to data visualized through Power BI. Integrating Power BI as a data source into ADOC allows users to monitor and ensure the dependability and integrity of their visualized data, facilitating real-time data processing and analytics.

Steps to Integrate Power BI as a Data Source

To add Power BI as a data source:

1. Click the Register icon from the left pane.
2. Click Add Data Source button.
3. Select the Power BI data source. The Data Source Details page is displayed.

Power BI Data Source

4. Enter a name for the data source in the Data Source name field.
5. (Optional) Enter a description for the data source in the Description field.
6. Enable the Data Reliability capability by switching on the toggle switch.
7. Select a Data Plane from the Select Data Plane drop-down menu. To create a new data plane, click Setup Dataplane.

8. Click Next. The Enter Connection Details page is displayed.
9. Enter the Power BI Tenant ID, Power BI Client ID, and Power BI Secret Key to establish a connection. Note Ensure the above Client ID is given application permissions [Service Principal] to be able to interact with Power BI via an application and choose to give read-only access and grant admin access. For more information, see Steps to Create PowerBi Service Principal.
10. Click Test Connection. If your credentials are valid, you receive a Connected message. If you get an error message, validate the Power BI credentials you entered.

11. Click Next. The Setup Observability page is displayed.
12. On the Setup Observability page, select the Groups to crawl; otherwise all groups will be crawled by default. Groups are a logical collection of Power BI entities, including datasets, reports, and dashboards organized to streamline collaboration and management within Power BI.
13. Toggle the Enable Crawler Execution Schedule toggle button. Turning on this toggle switch allows you to select a time tag and time zone to schedule the execution of crawlers for Data Reliability.
14. Click Submit for your new Power BI integration to be successfully configured. To view more details on the configured integration, navigate to the Register / Data Sources pages.

ADOC V3.1.0's integration with Power BI represents a significant advancement in data observability. By leveraging Power BI's powerful visualization tools within the ADOC platform, businesses can achieve deeper insights, improved data reliability, and more informed decision-making processes.

Tracking Lineage and Relationships for Power BI Data Sources

In ADOC for Power BI, data lineage specifically refers to the ability to track and visualize the flow of data from external data sources to Power BI, detailing each stage of data processing from its origin to its use in Power BI visualizations. This capability is essential for organizations seeking to ensure the integrity and reliability of data that powers their Power BI insights.

For ADOC to track lineage and relationships between Power BI and an external data source, integration is essential. This integration process typically involves connecting Power BI and the external data sources to ADOC, allowing ADOC to recognize and track data from external sources that Power BI utilizes.

Once the integrations are established, ADOC can pull metadata to map relationships between Power BI reports and their source data but only when the data source is cataloged or indexed within ADOC.

ADOC then provides ongoing visibility into how data flows from origin to visualization, helping organizations maintain data accuracy and trustworthiness across Power BI insights.

Lineage View:

Relationship View:

Steps to Create a Power BI Service Principal

To enable service principal authentication for Power BI admin APIs, see Enable service principal authentication for read-only admin APIs.

1. In the Microsoft Entra admin center, create a new app registration:

   • Enter a name for the registration.
   • Select Register to create the app.

2. In the same portal, create a new security group.

3. Add the service principal (the application created in Step 1) as a member of the group.

4. In the Power BI Admin portal, allow this group access to the Read-Only Admin APIs.

5. Add the created service principal to each Power BI workspace where you want to integrate with Acceldata Platform.

Supported External Data Sources by Power BI

The following data sources are supported in Power BI to get the derived asset information:

• DB2
• Oracle
• PostgreSQL
• MySQL
• MariaDB
• Azure MSSQL
• Snowflake
• BigQuery
• Databricks
• Redshift