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
4.88.0.16 Also tried on latest version2.100.1182.0 64-bit (December 2021)Any idea?
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.
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