'Power BI Desktop: Refresh data error 'Character set 'utf8mb3' is not supported

When I try refreshing dataset I get error:

An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'

Used to work fine before, I get data from a remote MySQL database on AWS server Checked collation of columns is utf8mb4_unicode_ci

  • .Net framework version: 4.8
  • MySQL connector version: 8.0.16 Also tried on latest version
  • Power BI Desktop version: 2.100.1182.0 64-bit (December 2021)

Any idea?

mysqlpowerbireactjstypescriptnext.jsredux-toolkitrtk-query


Solution 1:[1]

As of 24th May 2022, Mysql/NET connector version 8.0.28 should be the one in use on your PowerBI Desktop and On-premise gateway

Source of solution : https://community.powerbi.com/t5/Desktop/unable-to-connect-to-mysql/td-p/2493084

Solution 2:[2]

The issue has been resolved.

The report was built based on MySQL database However, MySQL database has been converted to MariaDB which caused utf8mb3 errors when establishing connection. The new connection was established using connector-odbc-3.1.4 available on https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.4/ And data source settings were changed from MySQL Database to MariaDB, which resulted in datasets being treated as a completely new source.

Solution 3:[3]

You need to narrow the error type down to FetchBaseQueryError first:

if (isError && error && 'status' in error) {

But generally note, that the data returned from the server will be unknown and you have to verify that it has the right structure and then manually cast it. It's an error after all, so also something unexpected could have wrong and it could have an unexpected structure as a result.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Devasya Dave
Solution 2 Anas Khateeb
Solution 3 phry

Related Questions