MySQL connection firewall whitelisting

[Anonymous]

Hi,

I need to connect Power BI to a MySQL database. I'm told the database is on a firewalled server so by default Power BI will be blocked from accessing the server. Please can you tell me what IP address / domain needs to be whitelisted on the firewall to enable access?

Thanks for your help,

CloudMonkey

[steve_ewing]

Since this is the top result on Google and there is no answer I'll necro the thread to add the link to MS Azure's ServiceTags.  They are the lists of IP addresses you need for each Azure service for each region.

https://www.microsoft.com/en-us/download/details.aspx?id=56519

[Anonymous]

Hi @Anonymous,

As far as I know, MySQL server listens on port 3306 by default, in your scenario, please open the port in firewall, and also add port number with server name(Servername:3306) to connect to MySQL in Power BI Desktop.

If the issue still occurs, please post full error message.

Reference:
How to Determine Which Port MySQL is Running On
Open Firewall Ports

Thanks,
Lydia Zhang

[greg2k]

Hi, @Anonymous 

I'm having the same problem as @Anonymous , my company has a tightly-secured MySQL database on a server and only trusted connections from the Internet can be accepted. Your proposed solution doesn't mention IP ranges or hostnames that the Power BI service uses when connecting to a MySQL database, and of course I couldn't find anything online despite being a fairly reasonable question.

Where can we find the IP ranges or hostnames that Microsoft uses when connecting to an on-premise MySQL database from the Power BI Service? My data is hosted in Nortern Europe (Ireland), but info for other regions would also help.

Thanks!