cancel
Showing results for 
Search instead for 
Did you mean: 
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

Accepted Solutions
ankitpatira Community Champion
Community Champion

Re: Cannot connect to local MySQL database.

@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

12 REPLIES 12
ankitpatira Community Champion
Community Champion

Re: Cannot connect to local MySQL database.

@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

sois
New Member

Re: Cannot connect to local MySQL database.

Perfect, thank you! I just downloaded the latest version and restarted  the app. It works now!

sau6402
New Member

Re: Cannot connect to local MySQL database.

@ankitpatira - Can you please share the x64 dowload link you are referring to. I installed x64 from this link but no success [I think we need .NET connector and not ODBC. I was unable to find .NET x64]

ovetteabejuela Impactful Individual
Impactful Individual

Re: Cannot connect to local MySQL database.

 @sois / @ankitpatira

 

Can you please share the link for the x64 version that works? Thank you.

rsmhema1993
Frequent Visitor

Re: Cannot connect to local MySQL database.

@ankitpatira can you plz share that link windows x64 connector? couldn't able to find that link...

fff
New Member

Re: Cannot connect to local MySQL database.

same problem. mysql doesn't offer 64bit .net connector and 32bit doesn't work with powerbi

getting: "this connector requires one or more additional components to be installed"

fff
New Member

Re: Cannot connect to local MySQL database.

Getting same error.  "this connector requires one or more additional components to be installed"

Have installed .net mysql connector 32bit.  Can't find a 64bit version anywhere.

 

kt2017
New Member

Re: Cannot connect to local MySQL database.

I downloaded the mysql connector from next url:

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

 

Please select for windows and 64 bit.

 

It works for me.

rskaskiw
New Member

Re: Cannot connect to local MySQL database.

It turns out that the version is of the MySQL connector is very important.  I wasted a lot of time trying to figure out why earlier versions -- some of them linked to in forums -- did not work.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors