Forum Discussion

spouros's avatar
spouros
Regular Visitor
3 years ago

Error on Autorefres

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.