Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

MySQL connection firewall whitelisting

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 I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    greg2k
    New Member
    6 years ago

    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!