Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
sois
New Member

Cannot connect to local MySQL database.

Hi All, I press get data and select MySQL datatabase. 

 

I get the following message:

 

"we encountered an error while trying to connect. the connector cannot be used because you are missing one or more required components.".

 

The Learn More link took me to the MySQL site to download 

mysql-connector-net-6.6.5.msi.

 

I downloaded that and nothing happened. I restarted my machine as well, no dice.

 

Windows 10, 32 bit office, 32 bit power BI.

 

Thank you.

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@sois Ignore that link and instead download x64 bit MySQL connector and install yourself. I have seen before where doing that has fixed the problem.

View solution in original post

37 REPLIES 37
Syndicate_Admin
Administrator
Administrator

Thank you so much. Nothing else seemed to work but this worked perfectly.

Syndicate_Admin
Administrator
Administrator

Thanks! this actually worked for me.

Syndicate_Admin
Administrator
Administrator

Try to check environment variables in your system and add server bin url  (c:\Program Files\MySQL\MySQL Server 8.0\bin) there. It should resolve.

JNP
Advocate I
Advocate I

if others have this problem try the following install the 8.0.30 version https://downloads.mysql.com/archives/c-odbc/  and the 8.0.32 version https://downloads.mysql.com/archives/c-net/  I have no idear why this works but it does

I am useing Version: 2.116.763.0 64-bit (april 2023) of Power Bi and im on Windows 11 

Hope it helps!

Anonymous
Not applicable

Can you please tell me what version of mysql do you use? 

Thanks a lot man you help me a lot  

Glad to hear it !

Fantastic, thanks! Solved it for me too

Thank you so much dear. I have been working on this issue for last 2 days. 

You solved my problem 

Glad to hear it ! I know the feeling 👍

I've been trying out different solutions for two days, this finally worked!  Thank you!!

MAAbdullah_47
Helper V
Helper V

Hi I have the same problem I tried many times nothing still been solved, please advice.

 

Have you been able to resolve it 😪

nerymuxson
New Member

You can try this solution, it worked for me.

 

Link: https://youtu.be/9h7MYoxQO6M

Anubha
New Member

I tried to connect power Bi with both 32 bit and 64 bit MySql connector . but non of them worked ,everytime getting an error that "this connector require one or more component" . 

 

Any help will be highly appreciated.

 

Thanks

my current MySQL installation (5.7.19) installed the Connector/NET 6.9.9; this produced the wellknown error.

 

Solution:

  1. using MySQLInstaller and uninstall the Connector/NET
  2. download version 6.6.7 from MySQL
  3. doubleclick the downloaded MSI-file for installing it
  4. any type of restart needed ? I don't know/remember

 Hope this discription helps

ankitpatira
Community Champion
Community Champion

@sois Ignore that link and instead download x64 bit MySQL connector and install yourself. I have seen before where doing that has fixed the problem.

Hi everyone, 

Can anyone help me. 

I just installed Power BI, and I cannot connect with Mysql database, it had the same error like this thread. My lastest version is v.8.0.33. 

I tried to download MySQL connector (the link is 32 bit), but when installed it not showed install, just show "repair, remove options", not have "typical" like some youtube video shared. 

I tried many times, but it still happened, please help me! 🙏

Yo tambien tengo el mismo problema .😪

Hi everyone,

 

I am running into the same issue with MySQL database/ connector issue. I am currently having version 8.0.33 installed on my pc. I start to get this pop-up error below when trying to get data into Power BI

 

NatashaT_0-1681996950346.png

 

Does anyone know how to get this issue resolved? Please advise.

 

Thank you,

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors