The enterprise data landscape continues to grow in volume and velocity as organizations leverage data to make informed business decisions and to stay competitive. It’s important to get an accurate view of an organization’s data, no matter where it resides, as key business decisions are made from this data. Recent integrations between Microsoft Purview and Power BI enable greater data agility.
Microsoft Purview is a unified data governance service that enables organizations to easily create a holistic, up-to-date map of their data landscape across on-premises, software as a service (SaaS), and multi-cloud sources, with automated data discovery. With Power BI integrations, data consumers are empowered to find valuable, trustworthy, sensitive data, and provide end-to-end data lineage for analytics users to build and trace key business metrics to the origins of the data.
In the following sections, you will learn about the mechanics of the Microsoft Purview and Power BI integrations.
Enable enhanced metadata scanning
As a Power BI admin, log in to the Power BI admin portal, go to the tenant settings, find the Admin API settings section, and enable the following three feature switches:
The image below shows these feature switches in the Power BI admin portal.
Once you’ve enabled the feature switches in the Power BI admin portal, the service starts caching the tables. Enhanced metadata is returned only for Power BI datasets that have been published/republished or refreshed successfully.
Register and scan in Azure Purview
Search and browse Power BI assets
Simply start typing the name of the Power BI asset in the global search box or use the structured browse experience to discover the correct Power BI assets in Purview. Just specify the keyword of your Power BI dataset, dataflow, report, or dashboard to let Purview’s intuitive search automatically complete and find the asset by relevance based on endorsement and sensitivity label. With a few clicks, you can narrow down the search results to specific Power BI assets in Purview.
Enhanced metadata in Power BI datasets
Trace end-to-end data lineage
In addition to the technical and business metadata, the scan of the Power BI tenant inside Purview brings in end-to-end data lineage so that data consumers can perform a variety of forward- and backward-looking scenarios, such as root-cause analysis and impact analysis.
Open in Power BI
With a single click, data consumers can open the Power BI service to the corresponding Power BI dataset for further analytics, root-cause investigation, impact analysis, management tasks, and dataset enrichment by adding more metrics.
Get started today!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.