Measure Killer Measure Killer

How do I find out who uses Excel on my semantic model, and which fields they use?

In an admin mode, fetch the activity logs and search for excel to get every user who connects to each model from Excel. Then collect their files and add them to the scan: Measure Killer shows which columns and measures each workbook uses, and they count as used in the cleanup.

Last updated · November 21, 2026

Steps

  1. Open Tenant Analysis and sign in with a Fabric Admin account.
  2. Click Activity logs in the toolbar (details).
  3. Keep the default 28 days, pick the activity types (only Excel is the fastest) and click Fetch.
  4. Search for excel. Each model expands into its activities, the users behind them and the application they used, with the last date and how many days they were active (details).
  5. Use Copy emails to ask those users for their files.
  6. Drag the .xlsx files into the analysis of the model, for example a Shared model online scan, and click Analyze (details).
  7. Each Excel file appears next to the Power BI reports. Expand it to see the columns and measures it uses. Those fields count as used, so a cleanup does not remove what a PivotTable depends on (details). Measure Killer reads the connection and the PivotTable fields of each file.

What you see

Activity logs filtered to Excel activities, with each semantic model expanded to its activities, the users behind them and the Excel application they used

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.