I'm building a dynamic workbook which uses the data from web... and mysql queries. When it runs for a while I'll get errors such as:

"Expression.Error: There weren't enough elements in the enumeration to complete the operation."

Then in the right "Queries & Connections" pane I see another error "Download not complete."

The properties for these queries are set to refresh every x minutes, and I've also got "enable background refresh" checked as well as "enable fast data load."

I can start solving this with trial and error (unchecking various configs) or trying to discover issues in the tables themselves.... but I'm curious if anyone else has seen these issues and resolved them. (And... when using the "data from web" connection does a browser have to be open?)

Thanks