Forum Discussion
Find the unused Measure/Data
Hi Power BI Community!
Is there a software/app or something in Power BI where I can find the unused measure/columns?
I just have too many created at some point which are now unused and to find all of them manually would be a pain...
Thankx for your time.
Hi Anonymous ,
You can create a list of this measures in DAX Studio to have a list of them, and use for retrieval.
This is the link to download and use Dax Studio:
https://exceleratorbi.com.au/getting-started-dax-studio/
There are related content and tools in the following link, I hope to help you：
https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/
https://exceleratorbi.com.au/measure-dependencies-power-bi/
https://exceleratorbi.com.au/which-columns-are-not-used-power-bi-data-model/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Anonymous , refer if this old solution can help
https://community.powerbi.com/t5/Desktop/search-unused-columns/m-p/873136
Hi Anonymous ,
You can create a list of this measures in DAX Studio to have a list of them, and use for retrieval.
This is the link to download and use Dax Studio:
https://exceleratorbi.com.au/getting-started-dax-studio/
There are related content and tools in the following link, I hope to help you：
https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/
https://exceleratorbi.com.au/measure-dependencies-power-bi/
https://exceleratorbi.com.au/which-columns-are-not-used-power-bi-data-model/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Use external tool Measure Killer to find and eliminate unused columns and measures
Hi,
I created an open-source web app to find unused measures and calculated columns in your Power BI project.
Check it out here
Link to Github: davispulins/pbi-reference-explorer
Upload your .PBIP project file and see:
- Which measures or calculated columns are still referenced
- Which report pages, visuals, filters, bookmarks, or report extensions use them
- Which model objects depend on them
Let me know what you think of the tool!
