Forum Discussion
Dataset Refresh Problem
Hi samgreene1 ,
For the SQL Server Connector in Power BI, it has a default timeout value limit of 10 minutes, which is mentioned in the official documentation of the Power BI SQL Server Connector. So there will be random errors when the data is refreshed:
Power Query SQL Server connector - Power Query | Microsoft Learn
Please try to set the timeout time for this connection when you connect to SQL Server Database with Power BI Desktop.
This is the related document, you can view this content:
Solved: Microsoft SQL: Execution Timeout Expired Error whi... - Microsoft Fabric Community
Solved: Microsoft SQL: Execution Timeout Expired - Microsoft Fabric Community
Timeout expired messages when connecting to SQL Server - SQL Server | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the suggestion. I have set the timeout to 15 minutes, however, I don't expect this to have a positive result as the report normally takes 1 minute 30 seconds to refresh.
After updating the timeout to 15 minutes, there is still a failure - but only in the morning.
