Load new data into queries with disabled loading

[Anon2005]

I have appended 4 queries into a new 'Super Query' and disabled loading for my source queries to decrease storage consumption and loading times. Therefore, if new data gets published for the source queries, it won't show in the 'Super Query'.

How can I fix this without re-enabling loading and disabling it every time?

Thanks in advance!

[BA_Pete · Accepted solution]

Hi @Anon2005 ,

Disabling load does not stop your source queries from updating when new data is available, it only stops them being pushed into the data model.

You may be getting confused with 'Include in report refresh' - Unchecking this WILL stop your queries from updating when you refresh.

Pete