Reorder Column Error

[melandiemcgee]

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.

[ray_aramburo · Accepted solution]

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. 

[melandiemcgee]

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.

[ray_aramburo]

Did you replace the values in the source, in the error queries or in the table query?

[melandiemcgee]

The source and error queries. The table query does not have the errors.