Lineage

Pick any column or measure and see everything it depends on, back to the data source, and everything built on it, down to the visuals and pages.

TrailsBI Lineage view with Units YoY Change selected on Microsoft's Competitive Marketing Analysis sample
Figure 1. The Lineage view on Microsoft's Competitive Marketing Analysis sample.

What it shows

  • Data sources, Power Query queries, tables, columns and measures, through to visuals and pages.
  • Select any card: what it depends on is highlighted on one side, everything built on it on the other.
  • Compact cards for the whole picture, detailed cards with usage counts when you need them.
  • Measures added in live-connected reports are tracked and shown apart from the model's own.
  • Point at any DAX or Power Query function in the code for its syntax, a short description and a link to Microsoft Learn.

Map and Graph

The Map shows the lineage in columns, from sources on the left to pages on the right. Graph shows the same items and links as one network, with the sources in the middle and pages and visuals on the outside. Both use the same filters, search and selection, so an item selected in one stays selected in the other.

Type filters hide whole kinds of item: parameters, queries, sources, tables, columns, measures, visuals and pages. Search finds any name across the whole project.

Answers these questions