Error : While connecting to SQL DB Table using Power BI DirectQuery

Hi Anonymous ,

Based on my research, the error might occurs in the following possibilities:

1. An instance of the SQL Server Database Engine is not running.
2. The SQL Server Browser service is not running.
3. The TCP/IP is disabled.
4. The server name was typed incorrectly.
5. There are network problems.
6. The TCP/IP port for the Database Engine instance is blocked by a firewall.
7. The client and server are not configured to use the same network protocol. 

Then for the solutions, please refer to following articles:

https://blog.devoworx.net/2017/01/30/connection-timeout-expired-pre-login-handshake/ 

https://social.technet.microsoft.com/Forums/en-US/84b08d13-ca15-4295-bf10-3a6f195fcf35/sql-server-prelogin-handshake?forum=sqldatabaseengine 

https://support.na.sage.com/selfservice/viewContent.do?externalId=83234&sliceId=1

https://www.kb.blackbaud.com.au/articles/Article/114624

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.