Forum Discussion
Problem connection Power BI to MySQL data source
For a homework assignment, I have uploaded MySQL for the first time, created a schema and table and populated the table with a few records. The recommended approach for downloading MySQL content into PowerBI was to use a "SQL Server" connection, but I got this error:
I assess from the message, that the host machine is aborting an established connection, that the problem is not with the connection string but in the host not accepting it. I did a little research on this, and the problem may be that the this feature has been retired:
https://docs.microsoft.com/en-us/collaborate/connect-redirect
Power BI does have the choice of downloading a MySQL database, but I'm having problems there too.
The error message link ("Learn more") points to https://dev.mysql.com/downloads/connector/net/, and I downloaded the item from the bottom of the page, but I keep getting the message. If anyone has solved the problem, I would like to know what they did.
Hi Peterfrb2 ,
Before we can connect to a MySQL database, we need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on our computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).
After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop.
If the connection still fails in Power BI Desktop, please check that if you are able to connect to the MySQL database in MySQL workbench, ensure that MySQL workbench is installed in the same machine as Power BI Desktop.(Note: Please understand that this link is provided above with no warranties or guarantees of content changes, and confers no rights.)
Best Regards,
Cherry
18 Replies
v-piga-msftResident Rockstar
Hi Peterfrb2 ,
Before we can connect to a MySQL database, we need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on our computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).
After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop.
If the connection still fails in Power BI Desktop, please check that if you are able to connect to the MySQL database in MySQL workbench, ensure that MySQL workbench is installed in the same machine as Power BI Desktop.(Note: Please understand that this link is provided above with no warranties or guarantees of content changes, and confers no rights.)
Best Regards,
Cherry
I can connect my data to workbench, but I am unable to connect the same database in power bi. I can't understand why? I have already installed mysql connecter also tried with both sql server connector & sql database connector
I'm facing the same problem. Can someone help?
I'm able to connect to mySQL workbench but not in powerBI. Could you please help? What might be the problem?
I have the same problem. Please someone help
- v-piga-msft
Hi Peterfrb2 ,
Have you solved your problem?
If you have solved, could you please share the solution or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
To do so, download and install the MySql connector from the URL below on your local PC.
https://dev.mysql.com/downloads/file/?id=507767
Note : No login required press on No thanks, just start my download.
Restart your Power Bi desktop and pick my sql as a data source from the get data menu.
In the dialog box, enter the server and database names, and you're good to go.
Banan
I have downloaded the lastest version of extension & installed it but its still the same issues
need help
Syndicate_AdminAdministrator
Thanks to you my problem is resolved now.
hello,
i have installed connector and still getting the same error.
i dont see connections option in SQL server community and i reconfigure sql workbench still getting the same error,
Please guide how can i resolve the issue.
Thank you
I feel as if I have tried every option, I still get the error message when trying to connect to a MySQL data source, any update on why this would be, or any solutions?
- Syndicate_Admin
If you have installed mysql connector/net and you are still having...
... then the problem may be that there is more than one version of MySQL Connector/Net noted in the .Net Framework config table.
I found that having tried to install a couple of versions of the connector, one or more of the uninstalls did not remove the entry in the .Net Framework configuration file. Once I removed all entries not needed, the above problem resolved.
My .Net Framework config table is...
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
This may be different for your framework.
My entries looked like this...
The entry in red was orphan from a previous installation attempt. The other entry matched the connector installed now. I removed the entry in red, rebooted and problem solved.
