Power Bi scheduled refresh failed due to error occurred during the pre-login handshake

[pbapuji]

Hi All,

scheduled refresh is failed for onprimises Sqkserver datasource  with the following error message
I have configured gateway and added the datasource successfully to the gateway but still it is failing

Kindly Help:

[v-xuding-msft · Accepted solution]

Hi @pbapuji ,

Please clear the global permission, re-connect to the data source and try to refresh manually in Desktop. Then republish the report to service and check if it works fine when you set schedule refresh. 

Moreover, make sure that you install the latest version (3000.10.232) of gateway and the latest version (2.74.5619.621) of Power BI Desktop. And please check if your dataset matched the gateway. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

[v-xuding-msft · Accepted solution]

Hi @pbapuji ,

Do the data source schedule refresh successfully? If yes, please mark helpful or prefer replies as answers. So that we are able to close the thread. More people will benefit from here. If no, do you try the way that I suggested? Is there any error message? 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pbapuji]

Hi @v-xuding-msft 

My deepest apologies, I was in sick leave, sorry for the delay.

I am checking now , will provide you the update ASAP. 

Thanks,
Bapuji.

[v-xuding-msft · Accepted solution]

Hi @pbapuji ,

Please clear the global permission, re-connect to the data source and try to refresh manually in Desktop. Then republish the report to service and check if it works fine when you set schedule refresh. 

Moreover, make sure that you install the latest version (3000.10.232) of gateway and the latest version (2.74.5619.621) of Power BI Desktop. And please check if your dataset matched the gateway. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

[pbapuji]

Hi All,

I have tried with latest version of the gateway, now it's successful.

Thank you so much for your help.

Bapuji. 

[aoliver]

Try to reset the gateway,

I solved some problems with auto refresh last week