Forum Discussion
How to setup Azure database for MySQL as data source in power bi service to allow auto data refresh
Hi nelsonym. Yes, you must install a data gateway on a VM in order to refresh a MySQL. I know you might be thinking "but it's on azure". For now that source needs the gateway. Only SQL Server and Posgresql are not using gateway from the azure DB services. You can read more about the connector here:
https://docs.microsoft.com/en-us/power-query/connectors/mysqldatabase
I hope that helps
Hi Ibbarau,
Thank you for the reply. Yes, I thought of installing the on-premise enterprise gateway and started doing it last night but I got stuck due to Region issue. It seems that it PBI and Azure services should be on the same Region. I'm still contacting Azure Support to allow us to move the services on the same Region with the PBI.
But I'm still not sure if this will work, as you mentioned the On-premise Gateway should be on the VM. Please note the Azure Database for MySQL is fully managed database service and we're using the flexible server mode. So how can we install the gateway on the VM?
I know it sounds silly because the service is on fully managed db on azure. Because the DB is on azure I would recommend creating a VM with windows on azure to keep the download and upload on the cloud. Otherwise it will be overkill if you do it on a local VM. Just make sure you can connect to the MySQL with the VM. You probably need to install a mysql driver and reboot the machine before installing the gateway. You can test conection with a udl file, desktop or a db tool.
I hope that make sense
I'm still waiting Azure support to allow us to move the database on the same Region with PBI before I could test this.
It's been more than 1 week since I requested them.
