cancel
Showing results for 
Search instead for 
Did you mean: 

Powerbi dataset refresh issue

hi, 

 

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.

moarshad_0-1603705625745.png

Regards,

Arshad

 

Status: New
Comments
Community Support

hi  @moarshad 

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.

 

Regards,

Lin

Regular Visitor

hi Lin,

 

Thank you for your suggestion, i have upgraded the gateway with the latest October-2020 version and the refresh is working fine now.

 

Regards

Arshad