Intermittent Scheduled Refresh Timing Out

[sperry]

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 demand	1/18/2021, 7:18:12 AM	1/18/2021, 7:27:41 AM	Completed
	Scheduled	1/17/2021, 9:01:16 AM	1/17/2021, 9:11:50 AM	Completed
Show	Scheduled	1/16/2021, 9:02:16 AM	1/16/2021, 9:11:41 AM	Failed	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.
Show	Scheduled	1/15/2021, 9:01:17 AM	1/15/2021, 9:09:12 AM	Failed	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.
Show	Scheduled	1/14/2021, 9:01:07 AM	1/14/2021, 9:07:35 AM	Failed	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.
	On demand	1/13/2021, 9:37:13 AM	1/13/2021, 9:37:27 AM	Completed

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?

[GilbertQ]

Hi @sperry 

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

[sperry]

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]

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.

[GilbertQ]

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]

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;