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?