One drive refresh not working

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.