cancel
Showing results for 
Search instead for 
Did you mean: 
0

Updated Gateway: Refresh Failures

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
Comments
Moderator

Hi @kellyholgate

 

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 

Frequent Visitor

I am also having this problem. Almost exactly as @kellyholgate 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?

Visitor

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

Frequent Visitor

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

Moderator

Hi all, 

 

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

 

Best Regards,
Qiuyun Yu 

Frequent Visitor

@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.

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....

Moderator

Hi @StephenMEMC

 

You can send a private message to me like below: 

 

q5.PNG

 

Best Regards,
Qiuyun Yu 

Frequent Visitor

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

Frequent Visitor

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