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
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v3 hours agoCommunity ChampionNew19Views1like0CommentsJustification Prompts When Downgrading or Removing Sensitivity Labels in Power BI Desktop
Description Currently, organizations can configure Microsoft Purview sensitivity label policies to require users to provide a justification when removing a label or lowering its classification. T...vvargasv19 hours agoMicrosoft EmployeeNew11Views0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley20 hours agoAdvocate IINew53Views7likes0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente21 hours agoRegular VisitorNew79Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez2121 hours agoNew MemberNew20Views4likes1Comment