search unused columns

[santiagomur]

Hi, 

i finish a report with to many clumns and i want to clean the model to engrease the performance speed. 

there is a way to know which columns are unused? 

they are going to change a few column name so I will have to update the visualizations, but first I would like to know where I use that column.

so how to know a column in which visualizations are being used?

[Brunner_BI]

Our external tool Measure Killer automatically finds unused measures and columns in your report/dataset.

[v-lionel-msft · Accepted solution]

Hi @santiagomur ,

You can refer to this answer:

https://community.powerbi.com/t5/Desktop/How-to-find-where-a-column-is-used/td-p/227623

Or try to use DAX Studio:

https://daxstudio.org/

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/

Best regards,
Lionel Chen

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