Forum Discussion
PowerBI to MySQL without gateway
Hi all,
I built a PowerBI dashboard that connects to a MySQL database. Currently this connection requires an on-prem gateway to schedule refresh in the service. I was wondering if it's possible to schedule refresh without the gateway. My device is very old and keeps giving me issues. Gemini told me to setup an Azure Database for MySQL but some people say I still need a gateway since it's not an Azure SQL database. The MySQL database is hosted on a Linux server so installing a gateway there also wouldn't work.
I'm willing to migrate but I'd like to know my options before making a commitment. Thank you!
Hi gang123
Indeed, with a Azure database for Mysql, you need a gateway
I see two solutions to fix this issue
1) Install your gateway on a virtual machine on azure, with a schedule to start and stop it when you need to use it to refresh your dataset
2) Migrate the data from mysql database to a sql server managed instance
Do not hesistate to ask if you need more help
2 Replies
Hi gang123
Indeed, with a Azure database for Mysql, you need a gateway
I see two solutions to fix this issue
1) Install your gateway on a virtual machine on azure, with a schedule to start and stop it when you need to use it to refresh your dataset
2) Migrate the data from mysql database to a sql server managed instance
Do not hesistate to ask if you need more help
What is the best way to migrate the database?
