Forum Discussion
Sept 2020 Desktop Update Error SQL Server during Pre-Login Handshake
Hi Anonymous ,
Update:
It is a known issue comfirmed by engineers:
Power BI customers using the September(SU09) Gateway or Power BI desktop with an on-premises SQL data source that has a self-signed certificate and "Force Encryption" set to Yes may experience issues with reports using Import or Direct Query modes and see the message "A connection was successfully established with the server, but then an error occurred during the pre-login handshake". As a workaround, customers can install a previous version of Gateway and Desktop versions as needed. Engineers have identified the root cause and an ETA for a fix will be provided soon.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Update:
It is a known issue comfirmed by engineers:
Power BI customers using the September(SU09) Gateway or Power BI desktop with an on-premises SQL data source that has a self-signed certificate and "Force Encryption" set to Yes may experience issues with reports using Import or Direct Query modes and see the message "A connection was successfully established with the server, but then an error occurred during the pre-login handshake". As a workaround, customers can install a previous version of Gateway and Desktop versions as needed. Engineers have identified the root cause and an ETA for a fix will be provided soon.
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.