Forum Discussion
Advocate IIReports stopped refreshing: Pre-login Handshake Error
Update:
Engineers are working on a fix which will be included in the October versions of Power BI Desktop and Gateway due to be released by 10/17/2020.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Allisond ,
Which version of SQL Server are you using to connect to power bi? Please check your power bi desktop version is the latest 2.85.681.0 64-bit (September 2020). Currently this version of power bi desktop seems have a known issue when connecting to SQL Server 2019. If your desktop version is updated to this version automatically and the SQL version is SQL server 2019, it could cause this issue.
You can try to use the previous version of power bi desktop like Aug 2020 temporarily to wait for the version fix.
In addition, you can also 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/
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.