Forum Discussion
Scheduled Refresh Fails When Gateway Machine Is Turned Off or in Sleep Mode
Hi Community,
I am using an ODBC connection to connect to a MySQL database as my data source in Power BI. I’ve created a report and published it to the Power BI Service.
To enable scheduled refresh, I installed the On-premises data gateway on my local laptop and mapped it successfully to the data source. The scheduled refresh works fine as long as my laptop is powered on and active.
However, the issue I'm facing is:
When my laptop (where the gateway is installed) is turned off or goes into sleep mode, the scheduled refresh fails.
This affects the data freshness of my reports, and I would like the report to always show the latest data from the database, even if my laptop is not available.
Additional Info:
I used an ODBC connection because the MySQL connectors (all versions I tried) didn’t work properly with my setup, so ODBC was the only option that worked.
How can I overcome this issue?
Is there a way to make the refresh work even when my laptop is off? What’s the best way to keep the data refresh running reliably?
Any suggestions would be greatly appreciated.
Thanks in advance!
Instead of using a personal gateway, you have to use a standard gateway and deploying it on a VM
The personnal gateway is more used with custom dev in Python or R than Database
5 Replies
- Deku
Super User
Run the on prem gatway on a cloud VM or a local server so it is always on. Depending on where your database is, you could also use a VNET gateway, but this requires premium
- Cookistador
Instead of using a personal gateway, you have to use a standard gateway and deploying it on a VM
The personnal gateway is more used with custom dev in Python or R than Database
v-ssriganeshCommunity Support
Hi Anonymous,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Deku & Cookistador for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.
Thank you.
- v-ssriganesh
Hi Anonymous,
May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-ssriganesh
Hi Anonymous,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
