How to fix the following problem for .net framework

Hi TanTanSC ,

Through the relevant document search, it is found that this problem seems to be related to the version of MySQL or .Net Framework in your data source.

One solution to this issue could be to change the character set of the MySQL database to utf8mb4 which is supported by .Net Framework. This can be done by altering the database configuration file and updating the character set to utf8mb4.

Another possible solution is to update the .Net Framework version to a newer version that supports the utf8mb4 character set. Alternatively, updating the MySQL connector to the latest version may also resolve the issue.

And if the MySQL database has been converted to MariaDB, this will also result in a utf8mb3 error when establishing a connection.
I found some related links where the same problem as yours was reported and has been solved. You can refer to the solutions there:
Solved: Problem with character set - Microsoft Fabric Community
Solved: Refresh data error: Character set 'utf8mb3' is not... - Microsoft Fabric Community
Power BI Desktop: Refresh data error 'Character set 'utf8mb3' is not supported (davy.ai)
Character set 'utf8mb3' is not supported by .Net Framework - Microsoft Q&A

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.