cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chrisamore514 Frequent Visitor
Frequent Visitor

Intermittent refresh failure: data source timed out

 

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

5 REPLIES 5
LilyS Frequent Visitor
Frequent Visitor

Re: Intermittent refresh failure: data source timed out

I'm experiencing the same problem. I have numerous (10) reports scheduled to refresh at different moments of the day only. Of those 10 only 2 have this problem and I can't figure out why.

I would deeply appreciate any input. 

Thanks in advance.

Community Support Team
Community Support Team

Re: Intermittent refresh failure: data source timed out

hi, @chrisamore514 

The Power BI team is the only ones that can speak Correlation ID. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
chrisamore514 Frequent Visitor
Frequent Visitor

Re: Intermittent refresh failure: data source timed out

Hello 

 

 

 

 

 

Community Support Team
Community Support Team

Re: Intermittent refresh failure: data source timed out

hi, @chrisamore514 

You'd better create a support ticket in Power BI Support to get further help.

 

Best regards,
Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
chrisamore514 Frequent Visitor
Frequent Visitor

Re: Intermittent refresh failure: data source timed out

We have gone down the Microsoft Support ticket path with this issue and they were unable to really help.  They made us jump through a lot of hoops, look at logs etc etc, only to have them say "upgrade and keep up to date the Gateway version" which we did and of course did not reslove the problem. 

 

I was hoping that someone in the community has resloved this issue.  

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 331 members 3,567 guests
Please welcome our newest community members: