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
**BUG** Please fix web model editor UI not working with role-playing dimensions
A key part of complex semantic models is the ability to reuse tables for scenarios like role-playing dimensions (e.g., Date table for DOB, Date table for SalesDate). I've specifically run into this w...arpost49 minutes agoPost ProdigyNew3Views0likes0Comments- fbcideas_migusr1 hour agoNew MemberNew323Views9likes3Comments
Favorites, recent fields and field groups in the Data pane (large models)
On big models the Data pane is a pain. Search helps, but you keep searching the same stuff again and again. And when a lot of fields have almost the same name (UN, UN METAS, UN_corr, UNIDAD_NEGOCIO…)...WildAnalyst1 hour agoNew MemberNew2Views0likes0CommentsAllow Workspace Admins to View Power BI Semantic Model Configuration Without Requiring Take Over
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Description As a Power BI Workspace Administrator, I understand why own...LeonardGreene3 hours agoNew MemberNew7Views0likes0Comments