About Motifworks

At Motifworks, we are AZURESMART. We are one of the fastest-growing cloud solutions providers, specializing in Cloud Adoption, Application Innovation, and Effective Data Strategies. Our passion is to empower you to accelerate your digital transformation initiatives using the Microsoft Azure cloud. We’re here to simplify your path to explore what’s possible.

Corporate Office

222 Courthouse Ct, #3G, Towson, MD, 21204, US

Regional Offices

Philadelphia ¦ Detroit

Development Office

101 Specialty Business Center, Balewadi Road, Pune- 411045, Maharashtra, India

Connect with us
info@motifworks.com +1 443-424-2340
Power BI Information Management through Lineage View-featured image

Power BI Information Management through Lineage View

 

This article was originally published on LinkedIn Pulse by our Data and AI Practice Lead, Tarun Agarwal.

Microsoft recently added a welcome edition to Power BI. Power BI now provides end to end visibility into entire metadata. We can see everything going on in Power BI. It provides a visual representation of how the information is flowing from dashboards to the dataset to dataflow to data sources to the gateway to source systems.

No alt text provided for this image

As Power BI adoption grows enterprise-wide and the number of users, workspace, reports, and dashboards grows to a large number, managing the environment can be challenging for report creators and admins. Tools like lineage view allow admins to identify impact analysis very quickly. The feature is a welcome edition for enterprise governance and monitoring.

The lineage view provides metadata for all objects in a workspace. It also allows for shifting to a different workspace lineage if a report is using objects from a different workspace.

Some of the features the view allows:

  1. Identify Certified and promoted datasets (more on this in a future article)
  2. Last refresh time of the dataset
  3. Ability to refresh a dataset
  4. Entities inside a dataflow or dataset
  5. Show lineage of any object
  6. Launch the object

The lineage feature allows performing impact analysis when something needs to change. Simply show the lineage of the impacted object will highlight the entire upstream and downstream dependencies.

The lineage view also allows diagnosing to refresh issues in reports and dashboards. Which dataset refresh failure is causing stale data in the report can easily be identified.

Power BI is continually adding new features to the product every month. A similar lineage view was earlier introduced with dataflow. Now Microsoft extended the functionality for all objects in Power BI.

Hopefully, Microsoft will not stop here and take it further to integrate with Azure Data Catalog. Azure Data Catalog is an enterprise data governance tool to provide visibility into metadata. With a future integration, Power BI will be able to go beyond Power BI metadata and show lineage with the system of records. That view will be genuinely empowering the data owners and data stewards.