When trying to manually refresh a spreadsheet connection to a WData query it fails (image below).
The connection was working fine previously and no changes have been made to the query or the sheet.
I've also checked that the amount of cells retrieved by the query is far below the maximum (2 million). In fact, if I set a connection to the same query on a different spreadsheet it works ok.
How can I find the root cause of the refresh issue?