MySQL ODBC Connector can not connect to data source

[Jan_Trummel]

Hello community,

I have installed a MySQL database on my computer, which I access with Power BI Desktop. I use the MySQL Connector/ODBC for this. As a MySQL user I use the root administrator account. The connection between MySQL and Power BI Desktop works very well.

MySQL Connector ODBC on my computer

Here is the Source step in Power Query:

= Odbc.DataSource("dsn=mysql2", [HierarchicalNavigation=true])

I also installed an on-premesis gateway on the machine with the MySQL database.

The gateway version is 3000.162.9 (February 2023).

However, when I upload the report to the Power BI service and register the data source in the gateway, I get this error message:

The data source cannot be created.
Unable to connect to the data source. Either the data source cannot be accessed, the connection timed out, or the credentials for the data source are invalid. Check the data source configuration and contact the data source administrator to troubleshoot.

Details:

[My gateway name]: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] The data source name was not found and no default driver was specified

The credentials are definitely correct. That can not be it.

Here is the complete configuration of the new data source (sorry, it's in German):

The configuration of the new data source

What am I doing wrong? I hope someone can help.

Greetings from Germany!

[lbendlin]

I also installed an on-premesis gateway on the machine with the MySQL database.

that is generally not recommended. They will fight for the machine's resources.

Check the firewall settings on that machine and open the port. Make sure you use 64 bit ODBC.  Consider using the .Net connector instead.