Error when creating MySQL data source in Power BI Gateway

[ehup]

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?

[v-qiuyu-msft]

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

[ehup]

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,
Jeff

[v-qiuyu-msft]

Hi @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

[ehup]

Yes, I have recently raised a service request for this issue.

[ehup · Accepted solution]

For anyone reading this thread, the problem was resolved by rebooting the PBI Gateway Server