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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Connection Timeout Expired Refreshing Data

Automatic data refresh fails after some night runs. By reuploading the pbi report file without any modification, the problem is solved and reappears after a few 3-4 refreshes.

The exception is copied below:

System.Data.SqlClient.SqlException: Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=5; handshake=14996;  ---> System.ComponentModel.Win32Exception: The wait operation timed out

Do you have any suggestions or ideas?

 

Thanks

Status: Needs Info
Comments
v-yuezhe-msft
Employee

@sato89,

Do you use SQL Server data source in your dataset? If so, could you please share gateway log here? Also please share your request ID and cluster URL contained in the error message in Power BI Desktop.

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Needs Info