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

200 W Townsontown Blvd, Suite 300D, Towson, MD, 21204, US

Regional Offices

Philadelphia ¦ Detroit ¦ Dallas ¦ Florida ¦ Cincinnati ¦ Ohio

Development Office

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

Connect with us
info@motifworks.com +1 443-424-2340
Don’t be a victim of cyber-attacks. Assess your Cyber security risks before it is too late! Know more ➜


Power BI lineage

Information Governance using Power BI Lineage View

Information Management through Power BI Lineage View

Power BI lineage view

Microsoft recently added a welcome edition to Power BI. Power BI lineage view 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.

Power BI consulting service providers help enterprises adopt Power BI and manage their solution as the number of users, workspace, reports, and dashboards grows to a large userbase. 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 Power BI lineage view offers are listed below:

  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 Power BI 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, data stewards, and Power BI developers. 

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

Fail to generate actionable business insight at scale?

Link your Synapse workspace in Power BI workspace to uncover intelligent insights