This brand-new product will let you run the Python package behind the Measure Killer Desktop application in a notebook within Microsoft Fabric.

​

This enables full automation, incl. scheduled runs + write the results to any destination.

​

Inventory

-Get a detailed view of your Power BI and Fabric tenant (capacities, workspaces, all items, domains etc.)

​​

Security + Access

-See who has access to what (users/groups, workspaces, individual Power BI and Fabric items)

-Mass grant access to workspaces (incl. personal ones).

-Mass remove access from workspaces.

-Get details on row-level security for all models (roles, security expressions + assigned users/groups)

-Find out who has access to which Apps and Audiences in Power BI

​

Consumption

-Get a list of all Power BI and Paginated reports with # of views down to the page level

-See how many users are building Excel files on top of your Power BI models

-Get a list of all Apps in your tenant and how often they are viewed

-Find out which reports have not been consumed in the last 14 or 30 days.

​

Data lineage

-From data source to semantic model (table level) -> see where a database view is used

-From semantic model to visual (column level)

-Find all unused columns from any semantic model across all connected reports

-Find all unused measures from any semantic model across all connected reports

​

Semantic model similarity

-Compare a semantic model against all other models in your tenant and get a similarity score

-This depends on dozens of factors like column names, relationships, tables etc.

-The output is a score between 0 and 1 how similar a model is (1 being an exact duplicate).

​

Optimization

-Easily clean up your semantic models by removing unused columns and measures (example below)

-Run best practices on all Power BI semantic models (customizable)

-Run best practices on all Power BI reports (customizable)

​

Refresh

-Get details on refreshes across all semantic models and dataflows (average duration, schedule etc.)

​

Governance

-See what users are doing in their personal workspaces (and if they share reports from there)

-Find uncertified custom visuals (potential security risk) in your Power BI estate

-Get a list of all duplicate KPIs (same DAX expressions) for all semantic models

-See which visuals or custom visuals are used in any reports in your tenant​

-Find out which reports are using visual calculations across your tenant​

​

Exports / Backups​​​

-DAX expressions (measures, calc tables, calc columns, report-level measures, visual calculations)

-M code (semantic models, Dataflows Gen1 & Gen2)

-Backup all reports (report layout / metadata)

-Backup all semantic models (TMDL code)

-Backup all dataflows Gen1 and Gen2 (M code)

-Export the lineage from dataflows/models to reports (incl. composite models)

 

For more details on any of these points, please visit Tenant Analysis which has screenshots from our desktop application.​​​​​​​