Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

MYSQL connector not working

I'm facing an issue with the MySQL connector in Power BI. Initially, I downloaded MySQL and successfully connected it using the MySQL connector. However, I installed the MariaDB connector when I wanted to import data using DirectQuery mode. Later, I switched back to MySQL for Import mode, but I started encountering the following error: "This connector requires one or more additional components to be installed before it can be used." Even though I have the MySQL connector installed, Power BI continues to show this error. I have already tried uninstalling and reinstalling Power BI, uninstalling and reinstalling the MySQL ODBC driver, reinstalling the MySQL connector, and repeating the installation process from scratch. Despite these efforts, the issue persists. Let me know if anyone knows how to troubslehoot this.

Need Help

4 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Icon for Super User rankSuper User
    1 year ago

    Hi Anonymous Try checking if the Power BI and MySQL Connector versions match (32-bit or 64-bit). Use the ODBC connector if the issue persists. Clear old connections from Data Source Settings in Power BI, update the PATH variable after reinstalling the MySQL Connector, and then try reconnecting.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Actually I have to fetch the data from MYSQL only (as gateway is configured to it) ,
    I have checked the  version of MySQL Connector and the Power bi and also cleared old connection from the data source settings, and also updated the path variable as well , still the issue presists.
    I'm not able to connect . it is showing the same error.
    below I have attached the Screenshots (the version that I have downloaded)
    Please Help me regarding this.

     

     

     

    • v-kathullac's avatar
      v-kathullac
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Anonymous ,
      Thank you for reaching out to Microsoft Fabric Community Forum.

       

      can you try with below mentioned points and let us know if you need any assistance.

       

      • Uninstall the 32-bit version of MySQL Connector/NET 9.2.0 and install the 64-bit version to match Power BI Desktop (x64).

      • Restart your system after installing the correct 64-bit connector to ensure all settings are refreshed.

      • If the native MySQL connector in Power BI fails, try connecting via ODBC instead (Get Data > ODBC).

      • Verify MySQL is accessible by connecting through MySQL Workbench using the same credentials and server.

      • Ensure the correct MySQL ODBC 64-bit driver is also installed on the on-premises data gateway machine if using Power BI Service.

      Regards,

      Chaithanya.

       

  • v-kathullac's avatar
    v-kathullac
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Anonymous ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

    Regards,

    Chaithanya