Query / Table deleted but causing error in another query? 2 hours going around in circles.

Hi Rhothgar As mentioned By SamanthaPuaXY It might be because of caching please try to filter them out

Add a Filter in the Query:

• Locate the step in your query where the list of tables is displayed (usually after the "Source" or "Navigation" step).
• Add a filter condition to exclude the unwanted tables
• Example M code :

FilteredTables = Table.SelectRows(Source, each [Name] <> "Number 3" and [Name] <> "Number 27")​

Apply the Filter:

• Right-click the "Name" column in the query editor.
• Choose Text Filters > Does Not Equal and specify the table names you want to exclude.

Refresh the Data:

• After applying the filter, refresh the query to confirm that only the necessary tables are loaded.