Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Microsoft SQL: Execution Timeout Expired while On demand Refresh in Service

Hello, I facing one error very randomly, sometimes refresh is completed, and sometimes it throws an error like this, 

"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. DataSourceKind = SQL. DataSourcePath = tcp:fisdata.database.windows.net,1433;FIS_Extracts. Message = Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. ErrorCode = -2146232060. Number = -2. Class = 11. </ccon>. The exception was raised by the IDbCommand interface."

whatever suggestion was given to the community I have already applied, like adding command timeout minutes at the source level in Power Query and also adding seconds in SSMS also.

Sometimes it works, but sometimes it again has the same error. Is there someone who facing the same issue again n again, and solved, please help me out with that?

Thanks.

1 REPLY 1
lbendlin
Super User
Super User

Do you have control over the data source?  Given the queries produced by Power BI can you optimize your database tables, indexes etc?

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors