Forum Discussion
Unable to connect to the data source undefined.
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
5 Replies
- lbendlin
Super User
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.
v-kelly-msftCommunity Support
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,
KellyDid I answer your question? Mark my post as a solution!- 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,
KellyDid I answer your question? Mark my post as a solution!
