Why does a new column in my SharePoint List data cause my data refresh to fail

[Bex]

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. 

[Syndicate_Admin]

Hello, were you able to solve it? I'm just in identical trouble... Thank you very much!

[Bex]

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. 

[Ritaf1983 · Accepted solution]

Hi @Bex 
You must go through all the steps starting with pulling data from PQ
Determine which step starts the problem and fix or remove it.

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