Forum Discussion
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 and in the query.
When I view the errors, it says reordered columns. But I did not change any ordering of the columns on the excel file. I can see certain columns have red and "error" in the cell. I fixed those on both the Excel file (prior to refreshing) and I even have tried to remove the error manually.
When I click close and apply changes, and refresh again, I get the exact same error all over again even though I am making modifications. I don't understand what's happening and this has never occurred. I just don't want to start all over. Please help.
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.
4 Replies
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?
