Forum Discussion
Post ProdigyIdentify Un used Measures delete bulk
HI Power BI Experts,
I am having almost 200 measures in my pbix file. In that where i need only 100 measures i am using in my report. I want to delete the un used 100 measures which are not using my report. I am not able to identify those measures directly, Is it possible to identify those measures and want to delete those. Please advice how can i delete those measures?
Hi prakash11440278 ,
To my knowledge, identify unused measures are not available directly in Power BI.
But I have found a submitted idea, you could give your votes at power bi site's feedback - Unused Measures
You could refer to these threads for more information:
Power BI File Clean-up In a Few Steps - RADACAD
How to identify Measures not used in your pbix file
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- vivran22
Community Champion
Hello prakash11440278
You can use an external tool called Power BI Helper
https://radacad.com/power-bi-helper.
Once you have connected it with the pbix model, you may find the following details handy (under Visualization tab):
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
prakash11440278- mahoneypat
Microsoft Employee
Check out the Power BI Cleaner tool too.
Tidy up Power BI models with the Power BI Cleaner tool – The BIccountant
Pat
Hi prakash11440278 ,
To my knowledge, identify unused measures are not available directly in Power BI.
But I have found a submitted idea, you could give your votes at power bi site's feedback - Unused Measures
You could refer to these threads for more information:
Power BI File Clean-up In a Few Steps - RADACAD
How to identify Measures not used in your pbix file
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
I created a web app to find unused measures and calculated columns in your Power BI project. It's open-source.
Check it out here
Link to Github: davispulins/pbi-reference-explorer
With the app you can 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
Currently it cannot bulk delete, as it is a read-only app, but it can be useful to quickly find unused measures without needing to download an external app like Measure Killer.
Let me know what you think of it!
