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:
DorisDB version: VeloDB-Doris 2.1.10
MySQL connector version: Connector/Net 8.0.26
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.
- S3 Torchconnector loads data as a list of tensors
- Postgres pg_dump dumps database in a different order every time
- Where can I get postal codes for all countries?
- The most suitable way to store encrypted data in Postgres
- Codeigniter autocheck db depending on session value
- Extending CI_Model for use with report database
- Difference between Data Model and Database Schema in DBMS?
- mongodb script file
- Case-insensitive search on a postgres ArrayField with django
- How do you maintain revision control of your database structure?
- How to convert hexadecimal to decimal on DB2
- How to unscape text from database in android studio
- Unable to cast object of type 'System.DBNull' to type 'System.String`
- Modeling Forward and Reverse Query Questions in Bigtable
- What's the better database design: more tables or more columns?
- When will clickhouse commit the consumed kafka offset in case of writing to distributed tables?
- How can I tell what Database format a file (or set of files) was created with (in Delphi)?
- SQL Server database change workflow best practices
- Export MySQL dump from command line
- Room - Schema export directory is not provided to the annotation processor so we cannot export the schema
- How to manually refresh a Snowflake Marketplace listing?
- Reset identity seed after deleting records in SQL Server
- How much do you normalize and/or denormalize in MongoDB?
- Does BCP create the destination object?
- how much normalization for a MongoDB database?
- Why is my Oracle tablespace growing so unreasonably fast?
- How to move a model between two Django apps (Django 1.7)
- add triggers manually inside my migrations with prisma ORM
- Optimistic vs. Pessimistic locking
- Add large files (exe, dlls, xmls) into cells of tables in mysql Database