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.
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.
@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.