Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Solved! Go to 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
Happy to help!
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
Happy to help!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!