Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Intermittent refresh failures: Data source timed out

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.

 

Cluster URI:

WABI-US-GOV-IOWA-redirect.analysis.usgovcloudapi.net

Activity ID:

3caf158c-4c1f-4339-a312-d4d70020289

Request ID:

dddf4348-ee7d-4540-ba23-5dbc6ee1700

Time:

2019-03-28 15:03:2Z

Status: New
Comments
kris999
Frequent Visitor

I'm having the same problems so I'm planning to set up a flow to refresh my most important datasets whenerver I get an e-mail in teams.
Far from ideal if you ask ma..

@Anonymous 
Can you confirm your solution solved the problem for you?

 

Anonymous
Not applicable

@kris999 yes, my solution solved the problem 100%. In my case the problem was multiple logons on the PC that was hosting the OPDG, which is a Win10Pro. I don't know if I would have the same problem on a Windows Server workstation, I haven't tried.

 

All the best!

Anonymous
Not applicable

Am also facing the same issue with the gateway. Its says me 

'Before the data import for undefined finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.'

 

The gateway was working fine till yesterday and now its showing this particular message.

 

All the datasources are online and gateway service is running.

 

SquanchTheGod
Frequent Visitor

Did anyone ever come to a resolution for this issue?
I recently came across this issue with some of our reports. I have tried just about everything others have used in this thread.