MySQL connector not working

Check the version of MySQL server and connector, if it's different try to install same versions

Hi Hsu_MM 

Here are some steps you can try to fix it:

• Make sure you’re using 64-bit versions of Power BI, MySQL Connector/NET, and MySQL ODBC. Mismatched architectures (like 64-bit Power BI but 32-bit connector) can cause these errors.
• Install the Microsoft .NET Framework 4.7.2 or higher if it’s not already installed, as MySQL Connector/NET requires it.
• When installing the MySQL Connectors, try running the installer as an Administrator (right-click > Run as administrator).
• After installation, it’s important to restart your computer to refresh system variables and let Power BI pick up the new components.
• Sometimes, the newer versions of MySQL Connector/NET may cause compatibility issues. If that’s the case, try installing an older stable version like 8.0.28 instead.
• Also, consider updating Power BI Desktop to the latest version, as newer releases often improve connector support.

Once you’ve done these steps, open Power BI and try reconnecting to your MySQL database. This usually resolves the "additional components" error.

If you still face issues, please share screenshots of the error and your setup details (Power BI version, connector versions, OS) so we can help further.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!