One drive refresh not working

[indhu]

Hi all,

I am a naive user and came across the One drive refresh option used for an hourly refresh of the files

followed this article: https://powerbi.tips/2017/08/best-practices-for-sharing/.

We created the power bi file and later published it to one drive. Once published, we used get data -> excel/files to get the .pbix file and the scheduled refresh option one drive refresh is turned on. Our data source will be azure and not sure what step I am missing. 

Problem: Hourly refresh is not turned on and it requires us to manually update. Went through a few posts in the community blog which suggested to use get data -> web instead of excel. I cannot find this option in web services. 

Any help is much appreciated. 

Thanks,

Indhu.

[Anonymous · Accepted solution]

Hi @indhu,

>>Once published, we used get data -> excel/files to get the .pbix file and the scheduled refresh option one drive refresh is turned on.

When you direct get pbix file from onedrive on power bi service, refresh option only trigger when that source file(pbix) updated. Any update/modify on datasource of pbix file not trigger onedrive refresh.

I'd like to suggest you take a look at following link to know more about this:

Creating a auto refreshing report on Power BI Service with CSV file saved on OneDrive as datasource

Regards,

Xiaoxin Sheng

[indhu]

Thank you @Anonymous 🙂