mysqlpowerbi

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

Any idea?


Solution

  • 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.