Forum Discussion
Error when creating MySQL data source in Power BI Gateway
Hi there
I have installed Power BI Gateway onto an AWS hosted server running 64 bit Windows 2012 R2. Following successful installation (the gateway is displayed in PBI with an "Online" status), I have proceeded to try to create a data source that connects to a MySQL database, which is defined with basic database user credentials. Upon trying to save the data source, the following error is displayed:
Details: "Cannot connect to the mashup data source. See error details for more information."
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 |
In my attempts to resolve the problem, I have tried the following:
- I have reinstalled the .Net framework
- I have installed the MySQL connector
- I have installed Power BI desktop and have successfully connected to the database
After these steps, the same error occurs.
Further to this, I have installed Power BI Gateway onto a local laptop computer running Windows 7 64 bit, on which Power BI Desktop and the MySQL connector were already installed. Using this instance of Power BI Gateway, I was able to successfully create the data source and have evidenced this by refreshing a data set through Power BI.
Can anyone shed any light on why this error is being raised on the AWS server hosted instance of Power BI Gateway - especially given that I am able to connect to the same data source using Power BI Desktop from the same server?
For anyone reading this thread, the problem was resolved by rebooting the PBI Gateway Server
7 Replies
Hi ehup,
Did you install the mysql-connector-net-6.6.5.msi from here( https://dev.mysql.com/downloads/file/?id=412152 ) on the server where data gateway installed? Please also update the data gateway to the latest version.
Best Regards,
Qiuyun Yu- Thanks for your reply
However, if you read my original message, you'll see that I have already installed the connector. This was evidenced by the fact that I was able to connect to the MySQL database from Power Bi Desktop, which was running on the same server.
Regards,
JeffHi ehup,
Have you updated the data gateway to the latest one? If issue issue persists, the issue should be related to the machine specific. I would suggest you create a support ticket to get dedicated support.
Best Regards,
Qiuyun Yu
v-qiuyu-msft wrote:on the server where data gateway installed
OMG finally. Thank you! I needed to know if I had to install it on the MySQL server itself (which I now realize wouldn't make any sense, since it already has the full installation on it), or the Gateway computer...
For anyone else with the same problem, we were in the same situation but our issue was that we hadn't signed in on the PBI Gateway on the EC2 instance. That solved it immediately.
