Troubleshooting "The server encountered an internal error and was unable to complete your request."
I'm getting a lot of failed charts in a report that I'm building, with all failed charts reporting "The server encountered an internal error and was unable to complete your request."
The charts are failing inconsistently. eg. If I refresh the data, charts 1, 3 and 5 will fail. If I refresh again, charts 1, 2 and 4 will fail. All report the same error.
On top of this, the "Refresh Data" option is taking 2 minutes+ to reload!
All the charts connect to a single BigQuery script data source. It's 11MB of data, and takes about 10 seconds to run if the same script is pasted and run from the BigQuery web interface.
The report was running fine yesterday.
How do I troubleshoot this? Is this a server error, and how do I get more detail on it?