This is a combined solution that you can use to identify unused objects in a pbix file. The scope is to identify those measures and columns from your report that are not used at all and could possibly be removed.
Steps we need to follow to gather the necessary information:
Here I can run different queries, but I didn’t find this enough for what I need, so I will only take some results and use them in the final solution.
In our final report, I have created 3 pages: for Measures, for Calculated columns, and another one combining both measures and calculated columns.
Please note that this method does not consider the measures and calculated columns used in Query Editor or Filter Pane, so you need to take a look in both places before you decide to remove an object.
This method allows us to combine useful outputs from DaxStudio, Power BI Performance Analyzer and Power BI and have it all in the same place. It offers a clear view of what objects we are not using anymore in our reports and helps us clean up our data model.
Click here to download the sample solution.
Cat image credit https://wallpaperaccess.com/cat-laptop
What do you think?
Hey, I was trying to follow this tutorial but I couldn’t find the file to download on this step: Open our custom NotUsedObjects report.
Thank you for your interest in our blog. I added a download link at the end.
There you will find a dummy example and you have to replace it with your own report.
Is it possible to do it when having Live data and not only Import data? Because I cannot get a localhost when I have live-data.
Thank you for your message. Localhost is mandatory. But you may want to try this option: https://www.youtube.com/watch?v=F-hoiNq9RfE
Thanks Cornelia for the information. Managed to clean a model without the need to install additional software ( other then DAX Studio that was already installed ). Some companies are very strict when it comes to installing additional tools.
Thank you for your comment!It makes me happy to read that you find it helpful!
Hi Cornelia, this is an excellent tool, and I appreciate the thorough documentation. It is exactly what we need. Thank you! Steve
Thank you Steve! I apreciate your feedback!