I am facing issue in refreshing few of the dataset after publishing the report.
The error message received is ""A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: HTTP Provider, error: 0 - )"
The refresh was working fine till last week but suddenly it start showing this error.
We are using Powerbi Sep-2020 version and the gateway installed is Oct 2020.
Any help or guidance is highly appreciated.
There is an issue about this and has been resolved.
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.
So try to use Powerbi Oct-2020 version to reconnect to datasource and republish again.
and also try to change from organisational account to windows account to have a test.
Thank you for your suggestion, i have upgraded the gateway with the latest October-2020 version and the refresh is working fine now.