How to setup Azure database for MySQL as data source in power bi service to allow auto data refresh

[nelsonym]

My PBI published on power bi service is using Azure database for MySQL as data source. How to properly create/configure this as data source to allow automatice data refersh. I'm trying to enter the credentials based on the detected data source but it is not working (unable to login). Do I need to create a gateway for this. The Gateway connection option displays this message:

What option should I take to connect to Azure Database for MySQL?

[ibarrau]

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

[nelsonym]

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?

[ibarrau]

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

[nelsonym]

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.