Error on Autorefres

[spouros]

Hello @all! I am trying to autorefresh my dataset kai reports on Power BI and i am getting this error message

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ip>10.10.16.10</ip>;amfare_admin"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: amfare_admin device_types.

I am very confused because my dataset was succesfully updated some days ago and now is this. Also, none of my scema values has the character utf8mb3. Does anyone has any idea? Is there anything wrong with the gateways? (The gateways seems to work fine)

[Anonymous]

Hi  @spouros ,

According to your error message should be a problem with the data source, is your data source MySql, refer to the following Link:

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.

Refer to:

Solved: Problem with character set - Microsoft Fabric Community

Solved: Refresh data error: Character set 'utf8mb3' is not... - Microsoft Fabric Community

Is your gateway up to date, if not, please update to the latest version or reboot your gateway to:

Update an on-premises data gateway | Microsoft Learn

Best Regards,

Liu Yang

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