Forum Discussion
How to find unused columns using DMV functions?
Hello,
Is there a way to pull unused columns with DMV functions in DAX or SSMS ? Power Pivot Utilities has this cool feature "list unused columns". Does anyone know if anything like that could be returned with DMVs, so a Power BI model could be queried ?
Thanks
Hi Anonymous,
Try to use the tool Dax Studio from marcorusso and AlbertoFerrari.
It as DMV formulas.
Regards,
MFelix
2 Replies
- MFelix
Super User
Hi Anonymous,
Try to use the tool Dax Studio from marcorusso and AlbertoFerrari.
It as DMV formulas.
Regards,
MFelix
You can use the $SYSTEM.DISCOVER_CALC_DEPENDENCY DMV, but it only shows internal model dependencies and completely misses columns used in report visuals. Because relying purely on DMVs is risky, the modern approach is parsing the .pbip and TMDL metadata directly to cross-reference everything.
This can be solved with this tool:
Stop Managing Power BI Technical Debt Manually. Build an Automated Auditor Instead – theBItoolbox
