Forum Discussion

wagahai's avatar
wagahai
New Member
4 years ago
Solved

Problem with character set

I have a report linked using a MySQL database as a data source. As I refreshed the data today, the following error shows "An error happened while reading data from the provider: 'Character set 'utf8m...
Need Help
  • wagahai's avatar
    wagahai
    4 years ago

    The root of the problem seems to be with MySQL 8.0.29. After downgrading to MySQL 5.7 everything works OK.

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi wagahai ，

The report is built on a MySQL database.
If the MySQL database has been converted to MariaDB, this will result in a utf8mb3 error when establishing a connection. And the data source setting is changed from MySQL database to MariaDB, which causes the dataset to be treated as a completely new source. Check if your database is converted to MariaDB.

 

similar error refer:

https://community.powerbi.com/t5/Desktop/Refresh-data-error-Character-set-utf8mb3-is-not-supported-by-Net/td-p/2298674 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien