scheduled refresh failing randomly due to execution timeout expired

[Anonymous]

Hi all,

I have published dataset into power BI service which is hosted in premium capacity and have scheduled dataset refresh for every 4 hours per a day but randomly failing  means one day two times is failing to refresh and in another day one time is failing to refresh and i am getting the below error message when the dataset refresh failed.

Can anyone help me on this how to resolve the dataset refresh failure.

Thanks in advance!

[djurecic · Accepted solution]

Hi @Anonymous , 

 This might be helpful to you:

https://community.powerbi.com/t5/Desktop/quot-Microsoft-SQL-Execution-Timeout-Expired/m-p/831355

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to the error information you provide, you encounter a random timeout error during data refresh, which occurs once or twice a day.actually for the SQL Server connctor in Power BI, it has a default timeout value limitation for 10 minutes, this is mentioned in the official document of Power BI SQL Server connector:

Power Query SQL Server connector - Power Query | Microsoft Learn

If you frequently met this SQL Server timeout issue during the dataset refresh or query execution process, you can try to manually set the timeout value for the SQL Server connector property in the original .pbix file of this report and dataset, for the reason why the refresh frequently face timeout error while automatically resolved after few minutes, I think this is depends on the performance of the data source. For the SQL Server, the more queries received at the same time, the slower the execution and processing of these queries will be. If the query completion time fluctuates around your default timeout time, the query will sometimes succeed and sometimes timeout, so I think the issue may disappear when you try to set the timeout inminutes property to “120” because this is maxium supported timeout inminutes property vaule.

Then you can apply the queries and republish the .pbix file to Power BI service to re-configure the gateway connection to check the dataset refresh again.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[djurecic · Accepted solution]

Hi @Anonymous , 

 This might be helpful to you:

https://community.powerbi.com/t5/Desktop/quot-Microsoft-SQL-Execution-Timeout-Expired/m-p/831355