Forum Discussion
Helper IIhow to Identify Unused Power BI Model Objects
Hello everyone,
I’m doing some cleanup on our Power BI models and noticed that many dashboards across the organization contain unused tables, calculated columns, fields, and measures. Has anyone used an effective method or reliable tool to identify which objects are not referenced in visuals, measures, or calculations? I’d like to streamline the models by removing anything that isn’t being used.
I would really appreciate your guidance.
Thank you!
DAX Studio
1. Connect to Service dataset (XMLA endpoint)
2. DMVs → Run:
SELECT * FROM $SYSTEM.TMSCHEMA_MEASURES
SELECT * FROM $SYSTEM.TMSCHEMA_HIERARCHIES
3. Cross-reference with visuals via Field List usage
6 Replies
- InsightsByV
Super User
Hi mjoseph111 ,
I would recommend you to download "Measure Killer" by Brunner BI. I use it all the times - once I finish my report development to optimize my Power BI model by identifying and removing unused measures, columns, and other objects. It helps keep the model clean, lightweight, and easier to maintain.
Link: https://www.brunner.bi/measurekiller
Please give a Kudo this post if you think my answer has helped you!
Thank you!
mjoseph111Thanks for your response, this one is paid , right?
- InsightsByV
Hi,
They also have a free version which I am using and it works!
- Kedar_Pande
DAX Studio
1. Connect to Service dataset (XMLA endpoint)
2. DMVs → Run:
SELECT * FROM $SYSTEM.TMSCHEMA_MEASURES
SELECT * FROM $SYSTEM.TMSCHEMA_HIERARCHIES
3. Cross-reference with visuals via Field List usage- mjoseph111
Kedar_Pande Thank you. I hope this helps..
v-karpurapudCommunity Support
Hi mjoseph111
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to InsightsByV and Kedar_Pande for those inputs on this thread.
Could you let us know if the suggested solution resolved your issue? If not, please share any additional details so we can assist further.
Best regards,
Community Support Team.
