Feature Request: Leave data as is when query results in error
I use your add-on to make BI reports for the clients of my company. Occasionally there is a problem with one of the data sources, like DoubleClick Bid Manager right now. As a result the queries result in an error and no new data is coming in.
This error however, also removes all the data the query has previously collected. I was wondering if it was possible, perhaps as an extra option?, that whenever a query results in an error, that the data it has previously gathered will remain intact. Ofcourse the error still needs to be visible on the SupermetricsQueries sheet.
Let me know what you think!