Data Gateway on OneDrive for automatic refreshes

[Kaskazi_Network]

Hi all,

I have a couple of power bi reports that read from a MySQL Database. Data changes regularly, so I have scheduled automatic refreshes after every hour and half using an on-premise data gateway installed on my PC's local drive.

I need to know if I can move this gateway to an online storage i.e Microsoft OneDrive so that my reports can refresh even when my laptop is off.

Is this achievable? If Yes, kindly advise how so.

Any assistance will be highly appreciated. Thank you.

[ibarrau · Accepted solution]

Hi. I wouldn't recommend moving from a DB to files. Files are more unstable sources because they are usually manually modified. The best practise would be installing the gateway in a 24 hours Local Server instead of your laptop.

Anyway. If you have files in a Microsoft cloud environment like azure, sharepoint or onedrive. You can avoid using the gateway and refresh without it. Here you have and example on how to connect those files:

https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive

Hope that helps

[Kaskazi_Network]

@ibarrau I really appreciate this advice. Mucho gracias..