Forum Discussion

pbapuji's avatar
pbapuji
Icon for Helper I rankHelper I
7 years ago
Solved

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

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:

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    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. 

    2.PNG3.PNG

    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's avatar
    v-xuding-msft
    6 years ago

    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.

5 Replies

  • aoliver's avatar
    aoliver
    Icon for Helper III rankHelper III
    7 years ago

    Try to reset the gateway,

    I solved some problems with auto refresh last week

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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. 

    2.PNG3.PNG

    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's avatar
      pbapuji
      Icon for Helper I rankHelper I
      6 years ago

      Hi All,

       

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

       

      Thank you so much for your help.

       

      Bapuji. 

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      pbapuji
      Icon for Helper I rankHelper I
      6 years ago

      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.