PowerBI to MySQL without gateway

[gang123]

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!

[Cookistador · Accepted solution]

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

[gang123]

What is the best way to migrate the database?