Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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: DataSou...
dataflow
General Comment
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Anonymous ,

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Anonymous 

    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?