Forum Discussion
Query / Table deleted but causing error in another query? 2 hours going around in circles.
Hi
This quandry has absolutely driven me nuts for the last 2 hours so I'm off to bed.
I cannot locate the issue.
Merged_Order_PL has been deleted. I have tried saving the file, closing the file, clicking Refresh All, all to no avail. You can see the left hand queries contains 25 queries but the content contains 27!!! Number 3 and 27 should not be there.
There is NO data quality indicator below the Content column so I cannot remove Errors!
How do I resolve this please?
And I thought I had learned so much this week. Now it seems my understanding has crashed back to Square One. So frustrated,
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.
3 Replies
Hi Rhothgar ,
Those tables could have been cached hence still showing up. A quick way is to just filter it away using the name instead
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.
Many thanks to you both.
I tried to give kudos and accept both solutions.
