cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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?

1 ACCEPTED SOLUTION
Frequent Visitor

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

View solution in original post

5 REPLIES 5
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Frequent Visitor

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

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors