Power BI, on-premises data gateway (personal mode) and MySQL - Invalid connection credentials

Hi all

I'm using Power BI to fetch data from a MySQL database (running on AWS) via the on-premises data gateway (personal mode) +  MySQL connector NET installed on Azure VM (running on Windows Server 2022).

On power BI (app.powerbi.com), the gateway is up and running but when I configure the data source credentials (with parameters server, database, authentication method - basic, username, password, tried encyption on and off for MySQL database) I get the following error:

Unable to update connection credentials. Invalid connection credentials.



Details: : The credentials provided for the MySql source are invalid. (Source at ***********.) Please have this information handy if you choose to create a support ticket. Session Id: 2cf0ede6-52e0-45a7-82dc-1775f919a1ac RequestId: 10ffc280-fc69-4ebd-b6d5-a1d760716d9c Cluster URI: https://api.powerbi.com Status code: 400 Time: Fri Nov 10 2023 16:01:53 GMT+0000 (Greenwich Mean Time)Please have this information handy if you choose to create a support ticket. Session Id: 2cf0ede6-52e0-45a7-82dc-1775f919a1ac Cluster URI: https://api.powerbi.com Time: Fri Nov 10 2023 16:01:53 GMT+0000 (Greenwich Mean Time)





On-premises

Virtual network

Interestingly, when I had the exact same setup on my Windows 10 machine (on-premises data gateway (personal mode) + MySQL Connector Net) talking to same MySQL database on AWS mentioned above, everything worked fine.

Could someone please help?

Many thanks.