Schedule refresh keeps resetting

[BruceAnderson]

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 know why it is occuring.  Is there anything I can check?

Also, is there a way to set a different email address for the refresh failures? Power BI service will only send to my admin PowerBI account, which has no email. 

[a_fman]

Having the same issue here. Will go into schedule refresh, turn the switch to Yes, setup my times, then apply. Popup indicates that was successful. If I then go to any other screen in the service and come back to it, it resets to No. 

The Refresh Now functionality works with no issue, but it is as if it doesn't save anything under Schedule Refresh. I just set one for 11am, and watched the logs, but nothing even showed in the logs.

Any ideas? This is fairly critical.

[a_fman]

Ah, we have a fix here. We had Reports and Datasets, but no Dashboards setup. Setting one of the report pages as a live tile on a dashboard allowed it to keep the Yes for Scheduled Refresh, as well as the times.

[TBenders]

My scheduled refresh also keeps resetting to 'No' the last few days. Without failing refresh... very strange. 

[TBenders]

Still having this issue. I set scheduled refresh, turn it on, I get confirmation, but then after a while its set back to Off.

Regarding the suggestions above:

 - I have active dashboards.

- Gateway is running

- This does not coincide with failed refreshes or refresh times

[v-qiuyu-msft · Accepted solution]

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

[BruceAnderson]

Many thanks for the response.

I did already check the things that you mention for the refresh, it is looking like the gateway had become inaccessible. 

I did vote for the idea you referenced just now!

[ankitpatira]

@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]

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.