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: 
chrisu

Schedule Refresh Issue

Submitted by chrisu Member on ‎03-07-2019 06:12 AM

Datasets on scheduled refresh fail and give the following error on the schedule refresh page:

 

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

 

There is no error on the refresh history, it just shows failed.  It is a different table name every day.  Refresh Now works for these datasets when I try them an hour or two later.  

 

I believe this started after I updated to the Februrary on-prem gateway.  

 

Status: Needs Info
See more ideas labeled with:
16 Comments (16 New)
Comments
v-yuezhe-msft
Moderator v-yuezhe-msft
Moderator
‎03-07-2019 11:37 PM

@chrisu ,

What is the data source of your Power BI report? Could you please export gateway log here?

Regards,
Lydia

v-yuezhe-msft
Moderator v-yuezhe-msft
Moderator
‎03-07-2019 11:37 PM
Status changed to: Needs Info
 
triafrog33
triafrog33 Frequent Visitor
Frequent Visitor
‎03-08-2019 01:47 PM

We are also experiencing these errors while refreshing our SQL database using the Scheduled Refresh, failures are intermitant. 

mbrough
mbrough Member
Member
‎03-11-2019 02:24 PM

Also getting these errors. Our datasource is on prem SQL database

v-yuezhe-msft
Moderator v-yuezhe-msft
Moderator
‎03-12-2019 01:08 AM

@chrisu @mbrough  @triafrog33 ,

I am unable to reproduce this issue on my side. Please open a ticket in Power BI support site.
Support Ticket.gif

Regards,
Lydia

Anonymous
Not applicable
‎03-12-2019 03:09 PM

Getting this as well.  prem sql, prem iSeries - ODBC, some domain XLS

This was only an issue after latest update for Gateway.  Had September GW version running and operating flawlessly until week ago.

 

Did anyone open a ticket as suggested?

mwaltercpa
mwaltercpa Regular Visitor
Regular Visitor
‎03-13-2019 08:08 PM

I am also getting these errors... It seems to happen to different dashboards each day.. and the table that is times out on changes on each refresh.

David_V
David_V Frequent Visitor
Frequent Visitor
‎03-14-2019 01:25 AM

Same problems for us after updating to the latest gateway (version 3000.1.257 (2019-02-24)) last week. The scheduled refresh randomly failed with the same error (data source timed out). It's a shame that it's impossible to roll back to a previous version of the gateway...

simonefraquelli
simonefraquelli Frequent Visitor
Frequent Visitor
‎03-20-2019 12:18 AM

Same problems for us using the latest gateway version: every time i get a timeout error on scheduled refresh

SAS_JamesGreene
SAS_JamesGreene Occasional Visitor
Occasional Visitor
‎03-20-2019 07:14 AM

Having exactly this issue as well.  Multiple refresh failures but no pattern.  Randomly failing, we had this for a few weeks and had hope the March update would resolve.  Problem still exists on march Gateway version.  Desktop client also fully updated

Idea Statuses