0x80040E4E Error - OLE DB or ODBC error Type mismatch error on data that has previously loaded ok

[shelbsassy]

I am getting this error when I try to load my dashboard that I have been loading for the past year with no problems but all of a sudden I get this error.  The only thing I did differently this time was I had to import it into Excel from a CSV file because it was 270k rows and it wouldnt load more than 80k from a tab delimited file.  Can anyone tell me what I can do to resolve this error message?  This dashboard is critical and I have been researching and troubleshoting but have not been able to find any solutions.  Thank you for your help.

[shelbsassy]

I went into the query editor and removed the changed type and that eliminated that error for now but now I am getting the error The function SUM cannot work with vaues of type String.  ????

[v-chuncz-msft · Accepted solution]

@shelbsassy,

It seems that some of the values can not be converted to decimal. Add a calculated column to have a check.

Column =
ISERROR ( VALUE ( Table1[Column1] ) )