Hello @Aidan Dowling, Thanks for reaching out on this forum
the general query succeeds but fails when the data refreshes.
What is the general query? is it from Desktop during the development phase?
During Data Refresh--The error might be due to the Schema changes in the source ? such as mis-match in column names, count, not-found etc,
Suggestion would be to try with a simple query from a different Cluster and Database from the one you are trying to access and see if the issue still persists.