How do I know if a sql query is being used in more than 1 table

[Syndicate_Admin]

Hello everyone,

I hope you can help me or guide me, I am a beginner in PBI, I am going to explain my problem, currently I have a dashboard, where the tables are created from a sql query, when I go to the transformation stage to see the queries I see 4 tables each with their respective queries but the ones that interest me are 2 (my job is to synplify those 2 tables) when I go to the modeling part I only see 1, my question is how can I know if the tables that querys are pulling and if they are actually all being used, so that I can then debug.

I will be very grateful for your help.

Best regards

[Syndicate_Admin]

Thank you very much, I did it just as you indicated

[Brunner_BI]

You can use external tools for Power BI like Measure Killer to find where columns/measures or tables are referenced.

[marcelsmaglhaes]

Hey @haznaran

If there are tables that you don't see in the Model view, they might not be used. However, it's important to verify whether the queries in the Power Query Editor that you don't see in the Model view are not used to generate other queries.

To do this, open the Power Query Editor and inspect the first step of those queries. Check if they reference another query in your Power BI file. If they do, it means they are contributing to the generation of other queries or data tables in your report. If they don't reference other queries and appear standalone, they may not be actively used in your report's data model.