Metaphor introduces the industry’s first end-to-end, column-level Power BI Lineage

Troubleshooting issues with reports, datasets etc in PowerBI is typically not an activity for the faint of heart. Without deep visibility into column level lineage it's near impossible to find why a report doesn’t show the information you were expecting to see.

An industry first, Metaphor now supports column level lineage for PowerBI Datasets. By parsing Power Query, Data Analysis Expressions (DAX), and native queries, Metaphor has the highest degree of lineage coverage compared to other solutions in the marketplace.

‍

“Metaphor's expanded capabilities including deeper Power BI lineage will deliver greater visibility to our business users of our data's lifecycle from source to reporting than we have ever had before." - Justin Swenson, Product Tech Lead, Sub-Zero

The importance of column level lineage‍

Column level lineage is important because it allows you to track the journey of data from its source to its destination. This is essential for troubleshooting issues, as it allows you to quickly identify where the problem is occurring.

For example, if you are seeing a discrepancy in the data between two reports, you can use column level lineage to identify the exact point in the data pipeline where the data is being changed. This can save you a lot of time and effort, as you no longer have to manually search through all of the different data sources and transformations.

Metaphor's Power BI lineage solution provides a number of benefits, including:

• End-to-end lineage: Metaphor provides lineage for the entire Power BI data pipeline, from the source data to the final report. This gives you a complete view of how your data is being used.
• Column level lineage: Metaphor supports column level lineage, which allows you to track the journey of individual data columns. This is essential for troubleshooting issues and understanding how your data is being transformed.
• Easy to use: Metaphor's Power BI lineage solution is easy to use, even for non-technical users. The intuitive interface makes it easy to find the information you need.

How to use Metaphor for Power BI lineage

To use Metaphor for Power BI lineage, simply connect your Power BI account to Metaphor. Metaphor crawlers will then automatically scan your Power BI environment and automatically build a detailed lineage map of all of your data.

Once the lineage map is complete, you can use it to troubleshoot issues, understand how your data is being used, and improve the overall quality of your data.

Conclusion

Metaphor's Power BI lineage solution is a powerful tool that can help you to improve the quality and reliability of your Power BI reports. With Metaphor, you can quickly and easily identify the source of data problems, understand how your data is being transformed, and ensure that your data is being used correctly.

‍

About Metaphor

The Metaphor Metadata Platform represents the next evolution of the Data Catalog - it combines best in class Technical Metadata (learnt from building DataHub at LinkedIn) with Behavioral and Social Metadata. It supercharges an organization’s ability to democratize data with state of the art capabilities for Data Governance, Data Literacy and Data Enablement, and provides an extremely intuitive user interface that turns even the most non-technical user into a fan of the catalog. See Metaphor in action today!