Connection Timeout Expired Refreshing Data

[sato89]

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

[v-yuezhe-msft]

@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