Skip to main content

Issues

New

Hi Guys, does anybody has the similar issue? I was unable to connect SQL Server ... Details: "Microsoft SQL: Connection Timeout Expired. The

Vote (2) Share
's profile image

on 01 Nov 2016 23:02:03

Details: "Microsoft SQL: 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=18158; handshake=14318;

Comments (1)
's profile image Profile Picture

Jon Webster on 12 Feb 2025 19:29:36

RE: Hi Guys, does anybody has the similar issue? I was unable to connect SQL Server ... Details: "Microsoft SQL: Connection Timeout Expired. The

Yes! My ODBC datasource takes more than 15sec to connect sometimes and PowerBI gives up on the connection way too soon. I am using the PowerBI Gateway and tried to adjust the timeout in the connection string, but PowerBI appears to ignore the connection timeout and doesn't even wait the default 30 seconds. Talking to powerBI support their solution was, make your datasource connect faster.My ask is that PowerBI follow industry standards and let us set the connection timeout or at least wait 30 seconds.