Intermittent refresh failure: data source timed out

Question

&nbsp;We are struggling with intermittent refresh failures. These failures occur across two different On-Premise Data gateway servers that we have.&nbsp; 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.&nbsp; It does not seem to matter which data source or which Gateway, we continue see intermittent failures of this type.&nbsp;&nbsp;Refreshes from Power-BI desktop do not have refresh issues.&nbsp;We have logging enabled on both Gateways but thus far, have not really found anything useful in helping identify the issue.&nbsp;We are using HTTPS mode on both Gateways&nbsp;Failure can happen both with schedule refresh and using the "refresh now" button&nbsp;&nbsp;Has anyone else run into issues like this?&nbsp;Last refresh failed: Thu Mar 28 2019 09:03:02 GMT-0600 (Mountain Daylight Time)&nbsp;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.&nbsp;Cluster URI:WABI-US-GOV-IOWA-redirect.analysis.usgovcloudapi.netActivity ID:3caf158c-4c1f-4339-a312-d4d70020289Request ID:dddf4348-ee7d-4540-ba23-5dbc6ee1700Time:2019-03-28 15:03:2Z

anonymous · Answer

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.

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
The Power BI team is the only ones that can speak Correlation ID.&nbsp;You could check the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/IssuesAnd 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&nbsp;https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
&nbsp;
Best Regards,
Lin

anonymous · Answer

Hello&nbsp;@v-lili6-msft,&nbsp;Unforunatally for me, and this might have to do with the fact that I worked for a government entity, I cannot log into support.powerbi.com to open a ticket.&nbsp; There seems to be some issue with my government email address/account even though we have a premium capacity in powerBI and I am my account is a capacity admin.&nbsp;&nbsp;&nbsp;When I try to log in, I get&nbsp;&nbsp;&nbsp;Having a government PowerBI domain is limiting in many ways and I assume this is just another limitation.&nbsp;

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
You'd better create a support ticket in Power BI Support to get further help.
&nbsp;
Best regards,Lin

anonymous · Answer

We have gone down the Microsoft Support ticket path with this issue and they were unable to really help.&nbsp; 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.&nbsp;&nbsp;I was hoping that someone in the community has resloved this issue.&nbsp;&nbsp;

Forum Discussion

Intermittent refresh failure: data source timed out

5 Replies

Related content

Refresh SQL Endpoint using semantic link labs: Intermittent failures

Refresh Failure

Report Refresh Failures

Scheduled Refresh Failure

Refreshing Failure

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