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
Set default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg1 hour agoNew MemberNeeds Votes7.9KViews1160likes105CommentsPower BI Dynamic Subscription Capacity Consumption and Recipient Processing
Issue: The concern is that the dynamic subscription workload can consume a significant amount of capacity when generating and distributing personalized report outputs. This creates a scalability conc...vivek1234413 hours agoMicrosoft EmployeeNew4Views0likes0CommentsSchedule pipeline as Service Principal
It would be beneficial to be able to specify an anonymous sp or user account while creating a schedule to run a pipeline directly in the Fabric GUI. This is currently only possible via the rest api a...Juriaan8091125514 hours agoNew MemberNew6Views0likes0CommentsImprove Databricks Native SQL Development Experience in Power BI
As organizations increasingly adopt Databricks as their primary data platform, Power BI remains a preferred tool for semantic modeling, visualization, executive reporting, and self-service analytics....Applsfan15 hours agoNew MemberNew5Views0likes0Comments