Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Type Mismatch Error

Hey   I've got an error with very little help from the error report:   Last refresh failed: 13/10/2023, 10:45:54 am There was an error when processing the data in the dataset. Data source erro...
Need Help
collinq's avatar
collinq
Super User
2 years ago

Hi Anonymous ,

 

The algorithms on the Service are much less forgiving than in the Desktop.  Type Mismatch is usually about having a field with a certain type where some of the data in the column are not that type.  
The fix is to go back to desktop and look and see if you have any "ANY" columns.  Make those a specific data type.  Also, check that you have DateFields that have only valid dates in them - that seems to be a consistent issue for folks.

You can also look and see if any columns have an "error" in the value field (this is hard to do sometimes if you have many rows and many columns).

You can also confirm that you have no fields that have "list" or "record" in the value.

joku50's avatar
joku50
Frequent Visitor
2 years ago

Hi collinq ! I had the same issue and your response here helped me fix the issue that I struggled for days to resolve 🙂 Thank you so much and I hope you have a wonderful day!