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.
Hello, I have one report, which dataset is SQL Server based. When I start on-demand refresh or Schedule for that report in Service, sometimes it is completed, but sometimes it gives me an error like the below,
"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
So, I have checked a few suggestions on that error here and I have applied also. Suggestions like, Adding Command Timeout at Source level in Power Query, and also I have added Execution Seconds in SSMS.
But after that also I'm facing this SQL Execution Timeout Error while Refresh, few times refresh was completed, but randomly it gives me this error.
Can anyone face the same error again n again randomly, and if you solved that? Please help me out with that Error.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous ,
By default, SSMS waits forever for a query to complete. If you get this error, this is because you have set a query timeout under Tools->Options->Query Execution->SQL Server->General->Execution time-out. You can also change it for the current window, by right-clicking and selecting Query Options from the bottom of the context menu. Set the time-out to 0 to wait forever.
For original post,you may refer to :
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. - Microsoft Q&A
Solved: MS SQL server timeout - Microsoft Power BI Community
Best regards.
Community Support Team_ Caitlyn