Unable to configure Gateway Connection to MySQL

[fxc]

We have installed the MySQL connector on the Gateway using MySQL mysql-installer-community-8.0.33.0.

In parallel we installed the Workbench to test the connection to our MySQL server: it worked.

We have rebooter the Server.

Then we went to app.powerbi.co to configure a new connection on our Gateway Cluster. But the creation of the connection fails with the  following error: unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.

But we found the connector installed at :
C:\Windows\Microsoft.NET\assembly\GAC_MSIL\MySql.Data\v4.0_8.0.33.0__c5687fc88969c44d\MySql.Data.dll

What can we do ?

(Here is the full error message:


Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.

Details:

BEPVM-Gateway: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.

Please have this information handy if you choose to create a support ticket.

ActivityId: e1aeee4e-1785-4998-a515-aab21bf7e2b1
RequestId: 67ac6968-50da-4a8b-a455-19d829f4ffed
Cluster URI: https://api.powerbi.com
Status code: 400
Time: Tue Jul 18 2023 18:56:01 GMT+0200 (Central European Summer Time)

)

And here are the details on our gateway and the server it runs on:

[Anonymous]

Hi  @fxc ,

Please check if your MySQL driver version is updated, Issue may resolved by using the version 23 MYQL driver.

Best regards.
Community Support Team_Caitlyn