Forum Discussion
Solved
Reorder Column Error
As I have done multiple times, I recently updated my data and attempted to refresh my dashboard. But this time, I keep getting the same error even though I have corrected the errors on the Excel file...
The error is that you have data type mismatches in columns Age and Pre-PNUR. Check on your source if you have string values in the numerical column and if you have some #N/A value on the text one.
Yes, that was the issue. For age, I replaced "unknown" with blanks as I don't have a value to enter. For Pre-PNUR, I updated the N/A to what needed to be there. When I try to save changes, or upload a new file with the changes, I keep getting the same error. The changes are not registering/saving it seems.
Did you replace the values in the source, in the error queries or in the table query?
The source and error queries. The table query does not have the errors.