Forum Discussion
Resolver IIsearch unused columns
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?
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://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-lionel-msftCommunity Support
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://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Brunner_BI
Impactful Individual
Our external tool Measure Killer automatically finds unused measures and columns in your report/dataset.
