topic Re: Identifying all unused columns and measures in Power Bi report in DAX Commands and Tips

Identifying all unused columns and measures in Power Bi report

Green_Cloud — Thu, 01 Sep 2022 20:20:26 GMT

Hello All,

I would like to identify all the columns and measures which are not used anywhere either in report development or building calculated measures in a power bi report. How can I do that?

Thanks

Re: Identifying all unused columns and measures in Power Bi report

AlexisOlson — Thu, 01 Sep 2022 20:33:34 GMT

Personally, I use the Best Practice Analyzer in Tabular Editor for this:

https://docs.tabulareditor.com/te2/Best-Practice-Analyzer.html#finding-unused-objects

I think Power BI Helper and maybe other tools can do the same thing but Tabular Editor is useful for many more things too.

Re: Identifying all unused columns and measures in Power Bi report

Green_Cloud — Thu, 01 Sep 2022 20:42:52 GMT

Tried Power Bi helper befire but it might be out of order now. nothing is being downloaded when i click the link.

Re: Identifying all unused columns and measures in Power Bi report

v-xiaotang — Tue, 13 Sep 2022 09:40:40 GMT

Hi Green_Cloud

you can try this link

https://radacad.com/power-bi-helper

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.