Measure Killer Measure Killer
What's new

New ways to keep your tenant healthy.

Find broken visuals before your report users do, see what every model costs in CUs, spot duplicates, and untangle complex relationships.

Coming in v2.9.5

Broken visuals detection

See immediately — tenant-wide — which reports contain visuals that render errors instead of data.

  • Broken visuals count per report, page and individual visual
  • Right-click to see which visuals broke and why — missing fields, broken DAX, broken filters
  • Combine with page views to fix high-traffic reports first
Docs →

Capacity metrics · CU consumption

Break down Capacity Unit consumption per capacity, workspace, item type, item and operation.

  • 24h and 7-day trend arrows show what's driving the bill and what's spiking
  • CUs column on the Semantic models tab — each model's cost next to its size and savings
  • History accumulates past Microsoft's 14-day window
Docs →

Find broken DAX tenant-wide

For every semantic model, see how many DAX expressions have errors.

  • Sort to surface models with broken measures or calculated columns
  • Jump to the DAX expressions tab to inspect the offending code
  • Pairs with broken visuals detection to see the user-facing impact
Docs →
Released in v2.9.4

Semantic model similarity score

Find similar — or even duplicate — semantic models across your tenant.

  • Spot duplicates (100%) and near-duplicates (e.g. 80% similarity)
  • Customize weights: tables, measures, M expressions, other attributes
  • Drill into details: what's identical, what differs
Docs →

Power BI report similarity score

Same idea as model similarity — but applied to reports.

  • Compare pages, visuals and report-level measures
  • Find duplicate reports across workspaces
  • Side-by-side breakdown of differences
Docs →

Table relations analysis

Reduce complexity in models with many relationships.

  • See which table can filter another (incl. via intermediate tables)
  • Browse every filter path between two tables
Docs →
Feature set

How teams use Measure Killer.

From tenant-wide governance to column-level clean-up — both built on the same scan.

Tenant Analysis Semantic models tab — used vs unused, potential savings, refresh history and storage mode per model
Tenant Analysis

Governance + insights for your whole tenant.

One pane of glass for every Power BI and Fabric item — metadata, lineage, access and usage.

Show all tenant analysis features

Inside Tenant Analysis

  • Full inventory · workspaces & every item type

    The complete inventory of your tenant: aggregate counts of every Power BI and Fabric item type (semantic models, reports, dataflows, lakehouses, notebooks and the rest), plus a detailed per-workspace table with owners, users, creation date, last activity, capacity assignment and item counts.

    Docs →
    Workspaces tab — detailed inventory with owners, users, item counts, and capacity assignments per workspace
  • End-to-end data lineage

    Trace every dependency from data source to report, across workspaces. Search the lineage view for a specific table or column.

    Docs →
    Tenant-wide data lineage view
  • Access & permissions

    Workspace and per-item access, with AD / Entra groups expanded so you actually see who has access to what.

    Docs →
    Access and permissions matrix
  • Semantic models

    Potential savings (% of each model that is unused), refresh history, schedule, average duration, tunable best-practice rules (choose which to run, adjust thresholds), KPI inventory and storage mode for every model.

    Docs →
    Semantic models inventory with refresh and best practices
  • Dataflows · Gen1 + Gen2

    Inventory every Dataflow with its M code, refresh stats and number of queries. Search across all M expressions.

    Docs →
    Dataflows inventory across the tenant
  • Apps & audiences

    All Apps — including organizational Apps — with audiences, 28-day consumption, contacts and access details.

    Docs →
    Apps and audiences tab
  • Reports · performance & usage

    Report opens and page views with page-level granularity, average load time per user and report subscriptions — rolled up per report. Consumption data accumulates beyond the 28-day limit so you build months or years of usage history automatically.

    Docs →
    Report performance and usage metrics
  • Broken visuals detection

    See immediately — tenant-wide — where a report renders an error instead of data. Every report shows how many visuals are broken, drillable per page and per visual; right-click to see exactly which visuals broke and why (missing fields, broken DAX, broken visual-level filters). Combine with page views to fix high-traffic reports first. Coming in v2.9.5.

    Docs →
    Power BI reports tab — Broken visuals column showing the count of broken visuals per report, page, and visual
  • Capacity metrics · CU consumption

    Break down Capacity Unit (CU) consumption per capacity, workspace, item type, item and operation — with 24h and 7-day trend arrows so you can see what's driving the bill and what's spiking. History accumulates past Microsoft's 14-day window, so you keep a continuous record of what each item costs.

    Docs →
    Capacity metrics — CU consumption broken down by capacity, workspace, item type and item
  • Custom visual consumption

    Every custom (non-Microsoft) visual across the tenant — which reports use it, how many users consume it, and whether it's certified. Spot uncertified visuals that could send data externally, and compare per-user counts against your license entitlements to find compliance gaps or overspend.

    Docs →
  • Fabric Notebooks

    Average run time, lines of code and language per notebook. Search every notebook for packages or keywords.

    Docs →
    Fabric notebooks inventory with language, lines of code, and run schedule
  • Export to JSON for AI or downstream tools

    Every slice of the scan — DAX, M, lineage, refresh events, RLS, best-practice violations, page-level consumption with load times, and capacity metrics — as raw JSON files. Feed them to a frontier AI for prioritized optimization suggestions, or pipe them into a governance dashboard.

    Docs →
    Measure Killer Tenant Analysis Exports sidebar — full list of raw JSON exports including DAX, M, refresh events, RLS, BPA, report opens / page views / load times, activities and more
Measure Killer Where-used table — used vs unused columns and measures with consumer breakdown
Used / Unused

Remove the unused. Break nothing.

Industry-best 99.99% reference-detection accuracy keeps cleanup safe — and your reports intact.

  • Spot every unused column, measure and table
  • Impact analysis: see what any change will affect
  • Subtle refs: conditional formatting, tooltips, nested measures
  • Tracks all Power BI reports, paginated, Excel and downstream models
  • From a single .pbix up to tenant-wide scans
  • Shrink model size, refresh times — and Fabric capacity bill
  • Best-practice analysis for implicit measures and anti-patterns
Show everything used / unused covers

Inside Used / Unused

What we analyze
  • Power BI reports (.pbix · .pbip)

    Local files or downloaded from the Service. Visual-level usage, page-level filters, report-level measures and mobile-layout artifacts.

    Docs →
    Measure Killer desktop analysis output — Where-used table with unused columns and measures highlighted in red after scanning a local .pbix file
  • Service reports & shared datasets

    Online thin / live reports analyzed without downloading — composite and child models, personal, Pro and Fabric workspaces. Full downstream lineage from a shared model to every report, Excel pivot and chained model.

    Docs →
    Measure Killer online mode — full lineage tree from a shared semantic model down to every connected Power BI report, paginated report and downstream semantic model
  • Paginated reports

    Same usage detection for paginated reports — parameters, embedded datasets and data sources included.

    Docs →
  • Excel files · Analyze in Excel

    Find which columns power your Excel users — pivot tables are detected by querying activity logs.

    Docs →
    Excel files in the dependency tree showing which columns and measures each workbook references from the semantic model
What we detect
  • Unused columns, measures and tables

    Across every report and model — with statuses like "Used in visuals", "Used in measures" or "Unused".

    Docs →
    Measure Killer used/unused output — every column and measure with used/unused status and where-used details
  • Calc groups · KPIs · field parameters

    Usage tracked for the modern model objects too — calculation groups, KPIs and field parameters.

    Docs →
  • Implicit measures & anti-patterns

    Spot implicit measures, unused calc groups, RLS gaps and other DAX best-practice violations.

    Docs →
    Best-practice rule settings with severity levels and individual enable/disable checkboxes
  • Column-level lineage

    For any column or measure, see every downstream visual and upstream source — your impact analysis, done.

    Docs →
    Measure Killer column-level usage details — every visual, filter, measure and other reference for a single column or measure
What you can do
  • Clean TMDL

    Cleaned TMDL of your model with unused objects removed — the fastest and safest way to optimize a semantic model nowadays. Apply via the TMDL view in Power BI Desktop or the Service.

    Docs →
  • DAX backup & restore

    Every DAX artifact removed via Kill DAX is auto-backed up and restorable with one click. Teams can share the backup folder via OneDrive.

    Docs →
    DAX backup and restore — right-click to restore a previously removed measure or calculated column
  • Save & resume an analysis

    .measurekiller files save the full scan results. Exit today, pick up tomorrow — or hand the analysis to a colleague who runs the cleanup under their own permissions.

    Docs →
  • 1-click cleanup — online

    Remove unused objects from semantic models directly — no round-trip through Power BI Desktop. Revertible via Power BI's built-in version history.

    Docs →
  • Clean your model — advanced optimizations

    Step-by-step suggestions to clean and optimize your model — remove unused artifacts, disable auto-datetime, find unused pages or visuals that might consume unnecessary columns of your model — each with an estimated size reduction so the biggest wins surface first.

    Docs →
    Measure Killer 'Clean your model' tab — numbered cleanup suggestions with per-item size reduction
The full list

Explore every feature.

Scan scope, detection, code search, governance, similarity, cleanup — every capability in one table, with docs linked from each row.

See all features
Free for desktop

Ready to clean up your Power BI?

Download the desktop edition free, forever. No data leaves your machine.

  • Free forever
  • No telemetry
  • MVP-built