MySQL Workbench 8.0 doesn't work

[Anonymous]

Hi there,

I've just downloaded the MySQL Workbench 8.0 CE and connected into my cloud database.
But when I try to get data, my Power BI desktop still saying:
" My SQL Database
This connector requires one or more additional components to be installed before it can be used"
I'm just beginner on SQL\data bases...

Any thoughts?

[Anonymous]

I had already entered on this link to download the sollution

https://dev.mysql.com/downloads/connector/net/

But downloded the wrong file. I've clicked on Recommended Download, and installed the complete Workbench, that didn't work.

Now I've just gone to Other Downloads and installed only the Connector/NET 8.0.19.

It works now

Ty

[v-yingjl · Accepted solution]

Hi @Anonymous ,

As we know, MySQL Workbench is just a visualization tool for users to show and edit database on premiss. If you want to connect to MySQL database to get data in power bi desktop, you should install the connector which is matched with your power bi desktop version(32bit or 64 bit)first :

https://dev.mysql.com/downloads/connector/net/

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ToddChitt]

@v-yingjl I know this post is old so I hope you can still help me.

Your suggestion is to download the MySQL connector that matches your Power BI architecture. Mine is 64 bit. But the link only shows 32 bit connectors. Where might I find a 64 bit MySQL Connector?

(Edited:) I take that back. My MySQL Installer shows that I have the X64 architecture installed for both MySQL Workbench and the Connector/ODBC. I have confirmed that my Power BI is 64 bit. But I am still getting an error stating: "This connector requires one or more additional components to be installed before it can be used."

WHAT components is it looking for? I'm lost.

Thanks in advance.

[amitchandak]

@Anonymous 

I think there is a connector for that you have to install that

https://geekdecoders.blogspot.com/2019/02/connect-power-bi-with-mysql-database.html

https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites

[Greg_Deckler]

Hmm, according to this thread it appears that your MySQL installation may need to be down graded:
https://community.powerbi.com/t5/Power-Query/MySQL-Connection-via-Desktop/td-p/329971