Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
For anyone reading this thread, the problem was resolved by rebooting the PBI Gateway Server
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.
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
@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...
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
Yes, I have recently raised a service request for this issue.
For anyone reading this thread, the problem was resolved by rebooting the PBI Gateway Server
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.