Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Recently I was following the dataflow update and I noticed an error but I didn't understand what it could be, can anyone help me? I am very grateful.
note: follow the error below:
Error: DataSource.Error: Microsoft SQL: A connection was successfully established with the server but then an error occurred during the pre-login handshake. (provider: SSL Provider error: 0 - The wait operation timed out.) Request ID:
Hi @vinicius_santos ,
Please check that if you have added the TCP port and UDP port(1434) in the inbound rule of the Windows Firewall, and you can verify TCP port in SQL Server Configuration Manager.
For more details about configuring remote access for SQL Server, please review the following blog.
https://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/
This is the related document, you can view this content:
Solved: A connection was successfully established with the... - Microsoft Power BI Community
Azure SQL Server: Error occurred during the pre-login handshake - Stack Overflow
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I will check the issue of releasing the ports, but I have another question, do I need to do these releases even if Power Bi DataFlow connects without a gateway to Azure?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.