Determine which data sources are used for which visuals

[Anonymous]

I am transporting a data source from representative xls data to live SQL data. In doing so, all the visuals are sourced to an xls file. I connected to a live SQL pull so that the dashboard has 2 data sources - xls and SQL. I manually updated all the calculations so that they read from the SQL table, and not the xls table. Is there a way to confirm that the xls file is not being used for any of the visuals, and that they are all using the SQL table Thanks

[v-lili6-msft]

hi, @Anonymous

After my research , I'm afraid it is difficult to achieve in Power BI for now.

A measure can contain multiple fieleds from data sources, and visual can contain multiple fieleds from data sources too.

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

Best Regards,

Lin