Measure Killer Measure Killer

How do I find unused queries and columns in a Power BI dataflow?

Open Dataflow Analysis, pick the dataflows and let Measure Killer find every dataflow, semantic model, report and paginated report downstream. Columns none of them use are your cleanup candidates. Consumers outside Power BI are not tracked, so check those before you remove anything.

Last updated · November 6, 2026

Steps

  1. On the welcome screen, open Admin modes and click Dataflow Analysis (details).
  2. Sign in, set the tenant filters and choose Search my whole tenant, so every consumer is found wherever it lives (details).
  3. Tick one or more dataflows (Gen1, Gen2 or Gen2 CI/CD) and click Next, then Analyze on the Selection tab.
  4. Read the Execution Summary: referenced and not referenced queries and columns, and the downstream dataflows, semantic models and reports (details).
  5. Open the Results tab and click Unused. That is your list of columns nothing downstream uses. Export takes it to Excel.
  6. Remove them in the Power Query editor of the dataflow. There is no automatic cleanup for dataflows yet (details).

What counts as used

Measure Killer tracks what Power BI uses: downstream dataflows, semantic models, reports and paginated reports, down to the visuals and filters. Excel files connected to those models can count too, but that takes extra work: collecting the files and adding them to the analysis (details).

Anything that reads the dataflow outside Power BI is not tracked: a notebook, a pipeline, another tool or a direct connection. Check those before you remove a column.

What you see

Dataflow Analysis result for a Gen1 dataflow: the execution summary with referenced and not referenced columns, and the Column lineage tab tracing each column to the semantic model and its visuals

Go deeper

Something wrong or out of date on this page?

Report an issue with this page

Tell us what is wrong or out of date. No email needed.