Determining which datasources/tables are in active use in a visualization/report

[kpad]

Hi everyone!

I have set up a few dataflows/datasources with a lot of tables, some tables I no longer need. I want to start cleaning up these tables, but I want to quickly ensure that none of the charts in my reports are dependent upon the tables that I want to remove. Other than clicking into each chart to see which table is in use, is there a quick way to determine this?

I've used the lineage view to determine which dataflows/datasources I no longer need and want to take it a step further.

Thanks!

[AlexisOlson · Accepted solution]

For this sort of thing, using an external tool like Tabular Editor or Power BI Helper is likely your best bet. Both are useful, so check them out.

https://www.sqlbi.com/tools/tabular-editor/

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