I was trying to connect SQL server, called it server A and server B. I can connect both servers on other apps, and I have no problems to get databases. On Power BI, I can only connect to server A. On server B, it shows --- Details: "Microsoft SQL: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment. 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=18201; handshake=14361; " There are something I tried but nothing work: use IP address instead of server name setup "command timeout in minutes" to 2, 10, 100, 100000 write a custom SQL statement in “SQL statement” turn off firewall open port 1433
2 Comments
- jwebsterNew Member
PowerBI currently times out connections in less than 15seconds. Please increase this timeout to 30 seconds, or use the property provided in the ODBC connection string!
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
F5 for presentation mode in POWER BI DESKTOP
F5 for presentation mode in POWER BI DESKTOP. In design time when we press F5 . 1) The canvas goes to fit to screen mode. 2) Visual headers will be hidden for visual components which set to hidden in...ndaneshi11 minutes agoNew MemberNeeds Votes103Views3likes2CommentsExpose Card Visual Reference Values to DAX via SELECTEDREFERENCEVALUE() or similar
Description The new Card visual introduces Reference Values and Reference Labels, which are excellent for displaying targets, benchmarks, prior periods, and other contextual metrics alongside a KPI....SEMattis1 hour agoAdvocate IIINew2Views0likes0CommentsData Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v1 day agoCommunity ChampionNew620Views11likes2Comments