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 IP address / domain needs to be whitelisted on the firewall to enable access?

 

Thanks for your help,

 

CloudMonkey

Need Help

3 Replies

  • 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!