Sharepoint List Dataset Scheduled Refresh not saving

[syedgj]

In PowerBI Desktop I created a report using data coming from a Sharepoint List. I then published it to PowerBI online, and both the Report and Dataset show up there just fine.

Now online, when I go "Refresh Now" for the dataset, it seems to be working as expected. But under Settings/Scheduled Refresh even though it lets me add various times for refresh, whenever I leave the page and return, the toggle is set to 'off' again. Essentially, the scheduled refresh settings aren't saving.

This is the final piece of the puzzle, as my data is being collected via a PowerApp.. If the auto-refresh can work then this can become an end-to-end 'hands-free' solution.

I'm using OAuth2 to connect to the Sharepoint List, and as mentioned, the manual refresh does work. So I'm assuming that's not the problem (as has been hinted in similar issues reported in this forum).

Thanks.

[v-qiuyu-msft]

Hi @syedgj,

From your description, the issue is solved now, right? 

Best Regards,
Qiuyun Yu 

[syedgj]

---

wrote:

Hi @syedgj,

From your description, the issue is solved now, right? 

Best Regards,
Qiuyun Yu 

---

Sorry for the delay in response.. yes this was solved.

[syedgj · Accepted solution]

Thanks for the reply Qiuyun. It actually did start working on it's own in the morning. It's doing what's expect now, fingers crossed!

[v-qiuyu-msft]

Hi @syedgj,

As you already set the data source credential correctly and set schedule time, does the refresh happen automatically based on schedule time? 

Based on my test, when we go to dataset settings, the dataset will evaluate the data source credential firstly, when it's valid then schedule refresh will show ON if it's turned on before. So you can wait for a while to see if schedule refresh is ON. 

Best Regards,
Qiuyun Yu