mysqlpowerbimysql-workbenchutf8mb4

issues connecting MySQL workbench to Power BI


I am unable to connect my DB to Power Bi after installing the correct connectors. Details: "An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'" The only place I can find utf8mb3 is under System variables > Other > character_set_system everything else is utf8mb4 utf8mb3 Error message

Unable to change value, have ensured all connectors are correct


Solution

  • On server side MySQL database has been converted to MariaDB which caused utf8mb3 errors when establishing connection.

    Downgrade MySQL/Net Connector to 8.0.28 and that seemed to fix the issue

    https://downloads.mysql.com/archives/c-net/