Is it necessary to use the Gateway for a MySQL server that is on the Internet?

[Syndicate_Admin]

Good day, in the company we have contracted a Cloud Server in which runs a MySql data server for the applications of our customers, this server is accessible from the internet on port 3306 with a public ip and its credentials respectively.
To be able to access from the Power BI service to the databases that are there, is it necessary to use and install the Gateway?

[Anonymous]

I have the mysql connector installed on my mcahine can I use the database connection to load the data into lake house without the gateway ? 

[Greg_Deckler]

@Syndicate_Admin Where is the MySQL database running, in Azure or somewhere else? If it is accessible via the cloud generally you do not need a gateway as long as the Power BI Service can connect to the IP address successfully (meaning there are no firewall rules preventing access).

[Syndicate_Admin]

Hello! thanks for the prompt response, the database does not run in Azure, it is a MySql server mounted on Centos 6 Ferozo Panel, the firewall has the rules created to access the service.
Example: from a database administration application installed on a PC I can access by placing the server name, username and password.

[v-yueyunzh-msft · Accepted solution]

Hi , @Syndicate_Admin 

According to your description, you want to connect to the MySQL service you installed on the server on top of Power BI Service.
First of all, for whether you need to install a gateway, you can enter: public network ip: database port number (which is similar to a cloud data source) when connecting to the data source, connect, and if successful, use "Data Source Credential" on Power BI Service to configure credentials to test whether it can be successful. If not, you need to check your firewall configuration.

For more information, you can refer to :
Data refresh in Power BI - Power BI | Microsoft Learn

Secondly, if you need to use the server's intranet to access your database, then you must install the local data gateway, install it on the computer where your server's intranet can access the Mysql database, and then configure the corresponding data source credentials on the data gateway for testing.

For more information, you can refer to :
On-premises data gateway - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly