Unable to connect to MYSQL Database from PBI Desktop

[gubhare]

Hi , I am trying to connect to a power BI desktop to MYSQL database installed on windows server 2019

My setting for power bi are as follows

Timestamp:
2024-10-15T10:33:40.9882966Z

Release:
September 2024

Product Version:
2.136.1478.0 (24.09) (x64)

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528049]

Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Model Version:
PowerBI_V1

MYSQL Database is 8.2.0.

MYSQL Data connector 

Connector/NET 9.1.0 has been installed . I have installed the connector and then restarted the power bi but still comes with the same error message as shown below

Can someone please help how to resolve this issue?

[gubhare · Accepted solution]

Finally, I managed to connect to the MYSQL data. I think the key here is you have to use the "Complete" option when installing. once it works on 8.0.31 version then it also works using the othger higher versions. If You thin this works for you as well then accept this as a solution to this very annoying issue. Hope it will help a lot of ppl 

whtch and do exactly as shown

https://www.youtube.com/watch?v=_Lk6EiLi5rY

[Anonymous]

Hi, @gubhare 

Thanks for rajendraongole1's reply. You can refer to his method, or try to using the following app version to connect to Mysql.

MySQL: 8.0.39.0 MySQL :: Download MySQL Installer (Archived Versions)
MySQL connector: 9.1.0 MySQL-connector-net 9.1.0 

You need to reopen MySQL and PBI Desktop after installation

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[rajendraongole1]

Hi @gubhare - can you please follow the solved thread.

Solved: This connector requires one or more additional com... - Microsoft Fabric Community

Solved: this connector requires one or more additional com... - Microsoft Fabric Community

Hope this helps.

[gubhare]

Hi Rajendra,

Thanks for your reply.

I installed prev version of connectors one at each time to see if it will make the connection but nothing seems to works . I tried from all version of connectors from 8.1.0