PowerBI Cleanup - is there a convenient way to see if an existing query/table is being used

[jofoster]

PowerBI Cleanup - is there a convenient way to see if an existing query/table is being used in an existing visualization or a measure that is being used an existing visualization?  I find it difficult to clean up legacy powerbi reports, and this one I have taken over from someone nolonger on the team.  Thanks

[v-cherch-msft]

Hi @jofoster 

Kindly mark the helpful answer as a solution if you feel that makes sense.

Regards,

[Anonymous]

When you click in a visualization, the tables, fields and measures used in that visualization turn yellow on the list of tables in the right-side of the screen

[Cmcmahan · Accepted solution]

The problem with this is that you have to click every single visual, some of which can be hidden and doing work behind the scenes.  For lots of reports, this gets tedious, quickly.

This tool does the job automatically https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper but there does not appear to be any way to tell natively.

[jofoster]

Thanks for the pointer