I have a fairly large query (19k rows) that used to run successfully but is now returning with "exception: the coordinates or dimensions of the range are invalid". The query runs fine inside of skyvia and I am able to do a full download to csv from here so it seems to be only inside of google-sheets. I deleted the sheet and created a clean/blank sheet with the same results.
Query - google sheet - exception: the coordinates or dimensions of the range are invalid
- Last Post 19 March 2019
I'd try accessing the query through the "Gallery" and then running it through the "edit" sql function. I've had problems for weeks now and was able to hack my way around it by going through those steps rather than "refresh sheet".
I can't even do that anymore. The Google Sheet functionality is broken from what they tell me and will take time to repair.