Forum Discussion
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...
The root of the problem seems to be with MySQL 8.0.29. After downgrading to MySQL 5.7 everything works OK.
Update - Solved when updated MySQL NET Connector to version 8.0.28. A tip : do not unistall your current connector version and install 8.0.28 directly from the .msi downloaded. Use "MySQL Installer - Community" instead to upgrade it. To test if the solution took effect, close PBI and launch it again - as per my experience the connector must be reloaded by PBI at launch. (btw, it did not worked with 8.0.29 in my case, but it could be the case that I did not relaunched PBI).