databasepowerbibigdataolap

Power BI connection to DorisDB fails with "Character set 'utf8mb3' is not supported by .NET Framework"


I am trying to connect Power BI Desktop to our Apache Doris database (which is the VeloDB-Doris distribution). I am using the standard MySQL data source connector in Power BI, as Doris is compatible with the MySQL protocol. My DorisDB server does not have SSL enabled.

When I enter the server credentials and attempt to connect, the process fails with the following error:

enter image description here

DorisDB version: VeloDB-Doris 2.1.10

MySQL connector version: Connector/Net 8.0.26


Solution

  • This issue is commonly encountered in Doris 2.1.x versions, particularly when using older versions of the MySQL Connector/NET driver.

    The root cause is that Connector/NET 8.0.26 does not support the utf8mb3 character set, which Doris uses by default in some internal configurations. This results in the error:

    Character set 'utf8mb3' is not supported by .NET Framework

    āœ… Solution Upgrade your MySQL Connector/NET driver to version 8.0.32 or later. This version includes support for the utf8mb3 character set and resolves the compatibility issue.

    After upgrading the driver, restart Power BI and try connecting again. The issue should be resolved.