Forum Discussion

zaidsaeh's avatar
zaidsaeh
Regular Visitor
6 months ago
Solved

Microsoft Power BI Desktop when trying to connect to a MySQL

 



I’m encountering an issue in Microsoft Power BI Desktop when trying to connect to a MySQL database. The application shows the message:

“This connector requires one or more additional components to be installed before it can be used.”

I clicked Learn more, downloaded and installed MySQL Connector/NET, and restarted Power BI, but the same message still appears.

Details:

Power BI Desktop version: 64-bit (2.151.1182.0)

Installed component: MySQL Connector/NET 9.6.0

The connection was working previously but stopped recently.

Could you please advise what might be missing or misconfigured?

Thank you.

Need Help
  • Anonymous's avatar
    Anonymous
    6 months ago

    Hi zaidsaeh ,

     

    Thank you for carefully following the recommended steps and providing an update. From your description, it appears the issue is not with installing the correct MySQL Connector for .NET version, but with Power BI failing to detect it within its .NET Framework environment. Power BI Desktop uses a .NET Framework-based MySQL provider, and Microsoft documentation states that the connector must be accessible to the .NET Framework runtime used by Power BI. Therefore, even after installing version 8.0.32, Power BI may request additional components if the connector is not fully available to the required framework. The previous advice was correct in noting that Connector NET 9.x is unsupported and reverting to 8.0.x is necessary. Your follow-up confirms that installing the compatible version alone does not guarantee detection, which is consistent with Microsoft’s guidance regarding the connector’s availability to the .NET Framework.

    Thank you.

7 Replies

    • zaidsaeh's avatar
      zaidsaeh
      Regular Visitor
      6 months ago

      Hi, thanks for your suggestion. I already installed the 64-bit MySQL ODBC driver, but unfortunately, it still does not work

      Power BI is showing the same issue.

      Please let me know if there’s anything else I should check.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 months ago

        Hi zaidsaeh ,

         

        Hi, this issue occurs because Power BI is not compatible with the newer MySQL Connector NET 9.x versions. Although you installed it properly, Power BI cannot detect it and continues to ask for additional components. This happens because Power BI’s MySQL connector still relies on the older Connector NET 8.0.x version that uses the .NET Framework. Installing the ODBC driver does not resolve this for native MySQL connections, as Power BI specifically requires the Connector NET provider.

         

        Your setup likely worked before because you had version 8.0 installed, but after upgrading to 9.x, it stopped being recognized. To resolve this, uninstall the 9.x Connector NET, install the 64-bit 8.0.x version, and restart Power BI. The MySQL connection should then function properly.

        Thank you.