Measure Killer is a Free Windows program in the Other category, developed by Brunner BI GmbH. The current version is 2.9.4; you can download it safely from its official source with the download button above.
Measure Killer can help you clean and optimize your tenant and datasets. This can drastically reduce dataset refresh times and thus lower the memory and CPU usage of your Premium capacity. Since we use the XMLA connection, the dataset can remain in the service. Additionally, we only analyze the metadata, we do not read the actual data in your dataset.
In this 5th mode of Measure Killer, we will be able to give an overview of the whole tenant and show e.g. which reports are using custom visuals or have report-level measures. Additionally, we will be able to provide an overview of all datasets and reports incl. number of pages, visuals etc.
Measure Killer can delete unused measures on its own if the user chooses so. Alternatively it can generate a C# script for the measures to be deleted via Tabular Editor manually.
Deleting unused columns will also improve performance since less RAM will be consumed.
Measure Killer will generate an M-Code to delete unused columns. This code can be pasted into Power Query's Advanced Editor to remove these columns from the model.
For every report analyzed, Measure Killer will generate a comprehensive Excel file to show where an artifact is used. This can be in: Measures, Visuals, Filters, Conditional Formatting, Joins in Power Query, or other parts of a Power BI Report such as Relationships.
Furthermore, Measure Killer can generate a chart to show the number of unused and used columns and measures.
📝 Release notes (2.9.4)
[FEATURES]
- Custom Calendar usage for columns (new Calendar feature in Power BI)
- KPI usage for all artifacts are now tracked in Measure Killer.
- UDFs metadata can now be analyzed for models in Pro Workspaces.
- Power BI REST API access tokens are now valid for the entire session (no re-authentication required).
- New status introduced: "Unused (remove manually)" for columns in calculated tables, report level measures, and other objects that cannot be removed automatically.
- New and improved execution log in Tenant Analysis and other modes.
[BUG FIXES]
- Missing datasource and gateway IDs in the Lineage tab.
- Error when adding Azure groups to workspaces in the Workspace Access window.
- SSL certification error caused by broken certificates.
- Issue where characters containing # were being erased from M queries in the UI and exports.
- Issue when fetching refresh events for Dataflows CI/CD Generation 2.
- Parsing error for Linked tables in M queries (Dataflows only).
- "Send dependencies upstream" failing for UDFs.
- Issue where rules were not processed before being verified when using Save/Load.
- Error when removing unused unloaded queries: 'NoneType' object has no attribute 'Value'.
- Misclassification of some organizational custom visuals as standard visuals.
- RecursionError (maximum recursion depth exceeded) when using Save/Load.
- Single line let in statements causing M expression parsing error: list index out of range.
- Unexpected error during license validation: too many values to unpack.
[MISC]
- Added new columns to the Semantic Models tab in Tenant Analysis: Used Size, Potential Savings, and Total Size.
- Improved sovereign cloud settings.
- Added a cutoff to the downstream models with no relationship warning message.
- Improved report selection by displaying the full path in Single Model and Report mode.
- Added unsaved changes warning to the similarity weights selection window.
- Improved the "fully optimized" message for Clean TMDL / One Click.
- Improved display and visibility of DAX best practice violations.
- Removed saved token from the auth file.
- Separated runtime from session duration for notebooks.
- Added RLS support to Model Similarity.
- Added object IDs to tenant exports.
- When loading a .measurekiller file, its metadata (name, timestamp, owner) is displayed in the window title and execution log.
SHA-256: 7469FF575A2F7EB48C6F314F236CFDDBE91EDA93328EE9D4C84E55BBEC15F32C
