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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kw_domadmin
New Member

HOW TO INSTALL MYSQL CONNECTOR on POWER BI (File>Get Data>mySQL db)

HELP! Installed MS Power BI Desktop so I can explore features using SQL data but I'm STUCK on this error:

 

kw_domadmin_0-1689067169630.png

 

I then select the URL on the dialog box and takes me here - MySQL :: Download MySQL Installer
I run the msi and install all the relevant connectors (for Win11 x64 OS)

 

kw_domadmin_1-1689067281301.png


I restart my machine 

I open Power BI Desktop 

I go to File > Get Data > mySQL database - SAME ERROR (WTH?!)

If anyone has experienced this issue and has a solution, I'd love some feedback. @Microsoft you need to fix this or provide a simpler solution via your KB. 

 

 

2 REPLIES 2
DataVitalizer
Super User
Super User


Hi @kw_domadmin 

A similar issue was faced and solved previously, please check this post https://community.fabric.microsoft.com/t5/Power-Query/Cannot-connect-to-local-MySQL-database/td-p/49...


Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

Hi @DataVitalizer 

Unfortunately no. These fixes suggest either x64 or earlier version of the mySQL connector but no luck. I suspect this is a bug that was likely caused by an infamous MSUS update that's killing applications without any awareness. 

Oh well, another application crossed off the MS list lol 

Thanks for the suggestion. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.