dataflow connecting to azure error

[vinicius_santos]

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:

[v-yangliu-msft]

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.

[vinicius_santos]

@v-yangliu-msft 

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?