Cloud based OneDrive scheduled refresh

[CloudMonkey]

Hello,

I have a dataset made up tables linked to OneDrive files. I was expecting to be able to schedule a refresh within Service directly to the OneDrive files but I think I have to install a Gateway. I don't want to do this because I don't want to rely on my computer being turned on. Please can you tell me how I can schedule a refresh directly from the cloud based OneDrive files? I see from the link below there is a way to do this by treating the OneDrive files as web data sources, but please can someone tell me whether this is still the best way to connect to cloud based OneDrive files?

https://5minutebi.com/2018/04/09/power-bi-using-and-refreshing-excel-datasources-with-onedrive/

Many thanks for your help,

CM

[v-frfei-msft · Accepted solution]

Hi @CloudMonkey ,

Gateway is not required for the excel file in One Drvie. Please refer to the online document about connecting to files stored in OneDrive

[GilbertQ]

Hi there

The blog post you read should work as expected and you have to ensure that it will be using the cloud data sources, which should then not require a gateway.