unable to connect to mysql

[liqila]

the connection works well until yesterday.

It says: Details: "An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'".

Any ideas on this? thanks

[redbenn]

I am having the same issue. Tried installing different versions of Mysql/Net connector, reinstalled gateway and no luck. The previous comment links to a database that was changed from MySQL to MariaDB, which is not my case either. It was working perfectly until this morning and nothing changed on the MySQL database

[redbenn · Accepted solution]

I downgraded my MySQL/Net Connector to 8.0.28 and that seemed to fix the issue 

https://downloads.mysql.com/archives/c-net/

[kt_analyst]

Thank you! This is the first thing that worked for me after spending at least 4 to 5 hours trying to resolve it with various older connector/net versions and other interventions.

[Adambk]

same!!

[liqila]

yes, that works. thanks very much

[amitchandak]

@liqila , Refer this solution

https://community.powerbi.com/t5/Desktop/Refresh-data-error-Character-set-utf8mb3-is-not-supported-b...

[liqila]

Thanks, Amit. Could you please advise how to do it? thanks.