Forum Discussion
Why does a new column in my SharePoint List data cause my data refresh to fail
I'm attempting to add 2 new columns to my dataset in Microsoft List. Once added and data entered, the data refresh fails. I receive the following message
"Processing error The following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table 'StategatesDuration' column 'Duration'. The data provider was unable to convert the value '' from the source data type 'VT_BSTR' to the expected data type 'VT_I8'. Please check the column data types in the data model and data source and ensure that the data types are compatible."
The newly entered data is throwing into columns in two other data tables which are set up to calculate duration of days but I can't determine why.
3 Replies
Syndicate_AdminAdministrator
Hello, were you able to solve it? I'm just in identical trouble... Thank you very much!
Hi
Apologies but no. I had a developer helping with the next iteration of our reports and he fixed it.
All I can suggest is searching for the codes in your error message - may help.
