I got inspired by Measure Killer to create an impact analysis tool
Hello everyone,
Just thought I'd share a bit of a coding adventure.
Measure Killer is a pretty great tool that allows you to do impact analysis on your semantic models.
It allows you to find out where each measure is used in each report down to the visual name. It can do a lot more than that, but I'm particularly a fan of this specific feature.
The problem is that the free version of Measure Killer is rather limited : you can't analyse reports that use Analysis Services for the semantic model.
For this reason, I set out to understand how a PowerBI Semantic model works, and create my own little tool for impact analysis.
The result is a small project called FindMyMeasure. It is a tool built with the dotNet Framework that allow the user to choose one or more pbix report, and start an analysis. The result is a list of measures, columns and hierarchies, with their usage level (Used, Unused and Used by Unused)
FindMyMeasure currently supports analysing Power BI reports that are connected in Live connection to an Analysis Services Tabular Model, and reports that are just in Import mode.
It still lacks a bunch of features, as well as some unit testing, but it fits my use case for now.
It is still very much a work in progress. I'm not a professional software engineer, and I do coding as a hobby.
Here is the code if you want to look into it :