I am unable to connect my DB to Power Bi after installing the correct connectors. Details: "An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'" The only place I can find utf8mb3 is under System variables > Other > character_set_system everything else is utf8mb4 utf8mb3 Error message
Unable to change value, have ensured all connectors are correct
On server side MySQL database has been converted to MariaDB which caused utf8mb3 errors when establishing connection.
Downgrade MySQL/Net Connector to 8.0.28 and that seemed to fix the issue
https://downloads.mysql.com/archives/c-net/