Error when refreshing from the web only

I have a dataset with some data sources like MySql and CSV.

When i refresh it from Desktop it works fine, if i upload it to web i get this error message:

I made a duplicate of the report and transferred one table at the time until i found the culprit... I had pivoted a table.

My date and time columns have no errors (obviously since i can refresh locally):

Any known solutions?

• Database is on Mysql and goes through a Gateway
• Files are on sharepoint, not connecting through Gateway
• Both datasources are used in other reports without issues.
• I've tried deleting the dataset and report.
• I have updated the Gateway (March 2021 update)