Intermittent refresh failures: Data source timed out
Submitted byAnonymouson03-29-201906:56 AM
I was asked to re-post this into this specific forum:
We are struggling with intermittent refresh failures. These failures occur across two different On-Premise Data gateway servers that we have. We have scheduled refreshes running all the time, against many different data sources (SQL DBs, Oracle DBs, ODBC connects etc) many times they work and other times they simply fail with this error message. It does not seem to matter which data source or which Gateway, we continue see intermittent failures of this type.
Refreshes from Power-BI desktop do not have refresh issues.
We have logging enabled on both Gateways but thus far, have not really found anything useful in helping identify the issue.
We are using HTTPS mode on both Gateways
Failure can happen both with schedule refresh and using the "refresh now" button
Has anyone else run into issues like this?
Last refresh failed: Thu Mar 28 2019 09:03:02 GMT-0600 (Mountain Daylight Time) Before the data import for BACK QUERY - ALL TYPES finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.