Forum Discussion

sois's avatar
sois
New Member
10 years ago
Solved

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 ...
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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! 🙏

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

 

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

 

Thank you,

  • rhalabi's avatar
    rhalabi
    Icon for Helper I rankHelper I
    3 years ago

    I don't know how to fix, but if I can confirm it's an issue with the v8.0.33 driver. If you install v8.0.32 it works fine. The v8.0.33 driver does not work with the On-prem gateway or Excel also.

    • Vipindas's avatar
      Vipindas
      New Member
      3 years ago

      I also had the same issue and it got resolved by downgrading the .NET agent to v8.0.32. 

       

      • rhalabi's avatar
        rhalabi
        Icon for Helper I rankHelper I
        3 years ago

        Yes, v8.0.32 does work fine, but v8.0.32 was flagged by our Security team as having a vulnerability which is why I upgraded to v8.0.33 which doesn't work.