Forum Discussion
Issues connecting Power BI to a MySQL DB
Hi Anonymous ,
Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your 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. You need to provide Server credentials not windows. See the similar case: SQL - "We couldn't authenticate with the credentials provided".
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.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your reply.
Yeah, I've read lots of different threads on here but none seem to help. I've tried adding and removing 4 different Connetors 8.0.14 to 8.0.17 and none work. 8.0.17 is the only one that gives the error message I mentioned initially.
I've got Workbench installed and can connect to the DB fine using that.
I'm definitely using the correct server details and entering details for the Database not Windows.
I've also just managed to get a connection to Tableau working using the same crednetials so I know they are fine.
the only thing I can think of is that it is a SSL issue. I initially couldn't connect using Tableau and their Support showed me how to create an SSL folder and an msql file that pointed to the cert location. I don't see a similar way of doing this for Power BI and annoyingly I can seem to find any way to talk to anyone at Microsoft about this.
Tom
Actually as a further update I installed the Connector you linked and removed all other Connectors. Now I get a different error. I assume this means I just need to find the correct Connector version.