Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

0

Updated Gateway: Refresh Failures

Submitted by Anonymous on ‎03-10-2019 04:29 PM

We keep getting intermittent failures on random datasets within our Power BI workspaces. This has been happening since we updated to the new February 2019 gateway. We were having some refresh failures previously due to the gateway timing out, so we thought that upgrading would resolve the issues. It appears to have exascerbated it. 

 

The errors look like the below: 

 

Last refresh failed: Sun Mar 10 2019 17:40:35 GMT-0400 (Eastern Daylight Time) 
Before the data import for Requests 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-EAST2-redirect.analysis.windows.net
Activity ID:aa4d9bb5-98b5-45a4-8749-4dbd3e36313b
Request ID:ecc6c044-0306-4ade-b631-5ea50740062c
Time:2019-03-10 21:40:35Z
Status: Delivered
See more ideas labeled with:
21 Comments (21 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎03-10-2019 11:25 PM

Hi @Anonymous, 

 

Please share gateway log files follow: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting

 

Best Regards,
Qiuyun Yu 

StephenMEMC
Advocate I
Advocate I
‎03-11-2019 08:32 AM

I am also having this problem. Almost exactly as @Anonymous explained it. I was on the October 2018 release and we were having some intermittent timeout failures. The support article I found suggested updating and that has definitely made matters worse. At least 15% of our refreshes are failing.

 

How should I upload the zip file that the Gateway exported out?

Anonymous
Not applicable
‎03-12-2019 06:50 AM

There is no option to attach a file in this comment field that I can find. 

StephenMEMC
Advocate I
Advocate I
‎03-13-2019 07:25 AM

@v-qiuyu-msft - do you have a preferred way for us to upload these files? I really need to work on getting this corrected.

v-qiuyu-msft
Community Support
Community Support
‎03-14-2019 12:29 AM

Hi all, 

 

You can upload the files to your OneDrive and send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu 

StephenMEMC
Advocate I
Advocate I
‎03-14-2019 05:55 AM

@v-qiuyu-msft - for some reason I don't have any ability to send you a PM either. I have the link ready but I don't see how to get it to you. When I go to your profile, I get an error.

PrahaPalalace
Frequent Visitor
‎03-15-2019 12:30 AM

We have a support ticket for an issue with the same symptoms. It has been open for 5 months with zero reported progress. After some weeks of investigation, it was passed to the SQL performance team, as this seems to be a common source type for reports with intermittent refresh failures. Still waiting for an update....

v-qiuyu-msft
Community Support
Community Support
‎03-15-2019 02:05 AM

Hi @StephenMEMC, 

 

You can send a private message to me like below: 

 

q5.PNG

 

Best Regards,
Qiuyun Yu 

StephenMEMC
Advocate I
Advocate I
‎03-15-2019 05:09 AM

@v-qiuyu-msft - Logs have been sent. Thanks.

StephenMEMC
Advocate I
Advocate I
‎03-15-2019 05:11 AM

@PrahaPalalace - where did you open a ticket? I tried to do so as well but for some reason couldn't get through. 

Idea Statuses