Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
1) 2 pbix in powerbi service
2) refresh schedule at 12am and 2am when nothing is running on our azure sql instance
2a) refresh durations range from 17 minutes to 3 hours ; refresh failures range from 1 hr to 2 hrs over 13 days
3) all data sources in both are set to 3 hr timeout
4) desktop refreshes work
5) error ":{"type":1,"value":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}}],"exceptionCulprit":1}}}
Solved! Go to Solution.
Hi @Anonymous ,
Firstly, if your dataset is too large, it will fail to refresh until you filter the data model back down under 1 GB.
Secondly, you may improve the performance for the data model, see Power BI performance best practices , Power BI Performance Tips and Techniques.
In addition, you may specify appropriate value in “Command timeout in minutes (optional)" following steps below, then check if you can refresh successfully in Power BI Desktop.
For example in the SQL Server connection page:
You may also refer to the article: SQL SERVER – Timeout expired. The timeout period elapsed prior to completion of the operation .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Firstly, if your dataset is too large, it will fail to refresh until you filter the data model back down under 1 GB.
Secondly, you may improve the performance for the data model, see Power BI performance best practices , Power BI Performance Tips and Techniques.
In addition, you may specify appropriate value in “Command timeout in minutes (optional)" following steps below, then check if you can refresh successfully in Power BI Desktop.
For example in the SQL Server connection page:
You may also refer to the article: SQL SERVER – Timeout expired. The timeout period elapsed prior to completion of the operation .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Note that #3 only impacts the Connection timeout, there is currently no way to set the Command timeout in Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.