Showing results for 
Search instead for 
Did you mean: 
BIsteht Regular Visitor
Regular Visitor

Unable to Connect to MySQL Database

I am having all kinds of issues when trying to connect to a MySQL database in the following scenario:


Enterprise Gateway on Windows 10 desktop

MySQL database on Linux box


I can connect to the database from the machine hosting the gateway using MySQL Workbench no problem. I can also connect to the datebase using Power BI desktop from outside of the corporate network as well. When I add my datasource to the Gateway the PBI service initially shows everything works fine. However, as soon as I manually refresh or run a scheduled refresh an error is thrown showing invalid credentials. Then the connection eventually gets blocked due to too many failed attempts to connect.


Any ideas?

Community Support Team
Community Support Team

Re: Unable to Connect to MySQL Database

Hi BIsteht,


Please check if the MySQL database server and on-premises data gateway are in a same domain or in the same local network. In addtion, please also check if the on-premises data gateway service is still running on the server.



Jimmy Tao

BIsteht Regular Visitor
Regular Visitor

Re: Unable to Connect to MySQL Database

@v-yuta-msft What are the requirements for domain and network configuration when working with MySQL or any other database? Can you provide those details or point me to a support article with the information. I can take that and work to solve the issue.