Auto refresh with Excel workbook on OneDrive

[peterscully]

Hi there.

To my knowledge when you connect the Power BI Service to a workbook stored on OneDrive, the service should refresh the data from the workbook every hour or so.  I have done this but when I update the information in the workbook and then click on Update Now for my dataset in Power BI, the data doesn't change.

When I first connect to the workbook and create the dataset I can go through to settings and see the autorefresh option under OneDrive under datasets is turned on.  

Then after my workbook in OneDrive has been updated, whether I just leave Power BI to refresh on its own or click on Refresh Now, the data doesn't update.  I also get an email saying "OneDrive refresh for testx.xlsx has been disabled. You can learn about common reasons refresh fails in our help topics or reach out to our Community for help. As always, you can also contact support."

If I then go look at the sync option under settings again it is then switched off.  Why is this?

I have managed to get this working in the past but currently am not having any joy.

Any ideas...

[v-yulgu-msft]

Hi @peterscully,

In my test, I could not reproduce your issue. The error prompts because the OneDrive refresh option is in Off status. 

This is very odd that the OneDrive refresh is switched to off if there is no one turn if off manually. So, in your scenario, please check whether someone else turned it off. And check whether this issue persists after you turn on the auto-refresh again.

By the way, there existing some delay to update the PowerBI dataset after updating the data stored in OneDrive.

Best regards,
Yuliana Gu

[peterscully · Accepted solution]

Hi Yuliana.

Thanks for the reply.  I actually think the problem has to do with my environment.  There seems to be a conflict in the way I'm saving my files to OneDrive which is preventing the syncing.  It might have to do with my OneDrive confirguration which I'm busy looking in to.

[v-yulgu-msft]

Hi @peterscully,

Glad to hear that you have found the cause to this problem. Now have you ever resolved your issue via checking the OneDrive configuration? If yes, would you please share your solution so that more people having similar problem can benefit from it.

Best regards,
Yuliana Gu