Scheduled refreshed the data using MySQL as database with turned off computer?

[Anonymous]

Hi, I have created a dashboard from Mysql as the database connector. Works fine on the desktop, have to manually refresh it. So, I published it on the service and I am surprised to see there is no (known) method of scheduled refresh from Mysql in a rather straight forward way??? I installed a gateway on my laptop but I can't have the laptop turned on all the time just for the refresh, we cannot have a VM as well just for a refresh as costings are an issue. What are the other ways where I can scheduled refresh (or even real-time refresh if possible) without having to turned on my laptop all the time?

[Anonymous]

Hi @Anonymous ,

You can consider migrating your MySQL database to a cloud-based data source such as Azure SQL Database or Amazon RDS. These cloud-based data sources support scheduled refresh and can be refreshed without the need for a gateway or a local machine.

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Brunner_BI · Accepted solution]

Yeah that is a limitation of MySQL unfortunately. I think there was some kind of solution by hosting it in Azure, which would enable the scheduled refresh, not sure though.