My file has 6 Queries:
(4 Pivot Charts loaded to “Pivot Tables and Data Model”)
(2 tables loaded to “Worksheet and Data Model”)
I can refresh each query individually and they update correctly. However, when I try “Refresh All”, I get the following error:
We couldn’t refresh the connection ‘Query - Tab1-TTL STORE‘. Here is the error message we got: The query ‘Tab1’ was not found.
If I try to continue refreshing next steps, I get the same similar messages “The query ‘Tab2’ was not found”
Yet, it works fine if I refresh each one at a time. At one point I did rename the queries (Tab1, changed to Tab1-TTL STORE, Tab2, changed to Tab2-TTL STORE_MFG, etc. ), so maybe that effected the data model? Any ideas without having to rebuild all my queries?