Forum Discussion

BruceAnderson's avatar
BruceAnderson
Helper II
9 years ago
Solved

Schedule refresh keeps resetting

I have a datasource which is an SQL connection, using the latest gateway.  When I save the Schedule Refresh to "Yes" it stays that way for up to a day, but then next day it is back to "No".  I don't ...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi BruceAnderson,

     

    In your scenario, I would suggest you check the Refresh History to find the detail information of the failure. Also please check if the personal or data gateway is available in dataset settings. Verify if any one modified the settings after you enable schedule refresh.

     

    In addition, based on my test, the schedule refresh failure email will be sent to the owner of this dataset, who sets this schedule refresh. Currently, we are not able to set prefer email address when the schedule refresh is failure, you can comment and vote on this idea: Scheduled Refresh failure notification should go to service/admin account.

     

    If you have any question, please feel free to ask.

     

    Best Regards,

    Qiuyun Yu

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

BruceAnderson Not faced this before but only reason i can think of is maybe your gateway becomes inaccessible for a short while and that coincides with the schedule refresh time which will be setting it to "No". But not 100% sure on that. You will need to check that with MS support.

BruceAnderson's avatar
BruceAnderson
Helper II
9 years ago

Thank you,  yes I had wondered if that was the case but hadn't noticed any instability of the server it is running from.  I will keep that in mind though.  Would really be great if the alert mail address could be changed though.  So annoying to need to go in every feew hours to check.