Forum Discussion

sperry's avatar
sperry
Resolver I
5 years ago

Intermittent Scheduled Refresh Timing Out

Hello - We have been receiving the below message for one of our published reports for which we have scheduled a refresh daily;

Before the data import for 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-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID:29b3132a-83c3-4525-8f2c-8b2f69730107
Request ID:022342b9-cc37-47fb-a2b4-0d4540690f18
Time:2021-01-15 20:11:41Z

 

Randomly a scheduled refresh will work and 'on demand' always works.

 
On demand1/18/2021, 7:18:12 AM1/18/2021, 7:27:41 AMCompleted 
 Scheduled1/17/2021, 9:01:16 AM1/17/2021, 9:11:50 AMCompleted 
Show
Scheduled1/16/2021, 9:02:16 AM1/16/2021, 9:11:41 AMFailedBefore the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.
Show
Scheduled1/15/2021, 9:01:17 AM1/15/2021, 9:09:12 AMFailedBefore the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.
Show
Scheduled1/14/2021, 9:01:07 AM1/14/2021, 9:07:35 AMFailedBefore the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.
 On demand1/13/2021, 9:37:13 AM1/13/2021, 9:37:27 AMCompleted
 

The model has 2 data sources connecting to a local server and we have put a 20 minutes command timeout in the settings;

Checked the server logs for the databases and no issues. Also checked ETL which build the tables in the databases and no issues.

Is there something we are missing that may cause intermittent issues?

Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi sperry 

     

    What happens if you change the timeout to 60 minutes.


    I would also remove the tick from "Include relationship columns" as this will then also query all the data from the related columns.

    • sperry's avatar
      sperry
      Resolver I
      5 years ago

      Hi GilbertQ 

      I made the suggested changes and was very hopeful that the solution had worked as I had 4 scheduled refresh successes in a row but alas this morning it failed;

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi sperry 

     

    I would check with your DBA to see what happens on the server at the time this happens?

    • sperry's avatar
      sperry
      Resolver I
      5 years ago

      Yeah checked all that out - small company so only a few of us overseeing all the IT operations..Failed every day since the 4 completed following the suggested changes;

       

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        5 years ago

        Hi sperry 

         

        I would then contact the data source owner to see if anything is happening at that time?

         

        Also make sure that the Gateway Server has enough memory, CPU and bandwidth when the dataset is updating to make sure it can get to the Power BI Service as quickly as possible.