cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vinicius_santos
Regular Visitor

dataflow connecting to azure error

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:

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

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.

@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?

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors