Unable to connect to the data source undefined.

[Anonymous]

Hi all, I have successfully installed gateway on Windows server 2012 R2 and the gateway is online but when I configure the datasource I get the below error: I am not sure what exactly the problem is? How should I add data source for mysql ODBC connection. I am able to connect to the datasource from Power BI desktop.

Underlying error code: -2147467259 Underlying error message: MySQL: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885

[v-kelly-msft]

Hi @Anonymous ,

Check the similar thread below:

https://community.powerbi.com/t5/Power-Query/Power-BI-Desktop-Unable-to-Connect/td-p/8606

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

I am not sure I am already using the latest version of mysql connector. 

[v-kelly-msft]

Hi @Anonymous ，

Try to uninstall and reinstall the latest version of mysql connector via below link:

https://dev.mysql.com/downloads/connector/net/6.6.html

If this doesn't work,pls create a support ticket via below link and our relevant personnel will help to handle it.
https://powerbi.microsoft.com/en-us/support/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[lbendlin]

As the error message says - you need to install the MySQL ODBC driver on the gateway, and configure the connection in the ODBC control panel.

[Anonymous]

I am not sure If this is possible? Also my gateway which is installed on Windows server shows "Not configured correctly"