Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
v-lili6-msft
Community Support

hi  @Anonymous 

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

Anonymous
Not applicable

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