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."
|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:
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?
Solved! Go to Solution.
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.
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.
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.