Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Importing excel data that contains #N?A values

Hi   When I am importing data or a table from excel into powerquery that contains a #N/A value in cell I get a an 'Error'.  When I click on the error or link, which is diplayed in the field, the de...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    there are 2 options "remove errors" and "replace error" in Power Query Editor

    Right-click to columns that contains errors and choose appropriate option

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

there are 2 options "remove errors" and "replace error" in Power Query Editor

Right-click to columns that contains errors and choose appropriate option

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

kymramosrpo's avatar
kymramosrpo
Advocate V
2 years ago

'Remove Errors' worked for me! Here's my case:
- Data source was an Excel file from a SharePoint folder

- Date column was sorted in descending order and resulted to, 'DataFormat.Error: Invalid cell value '#N/A''
- Traced back a few steps and found that another column, a string column, had errors: 

- Right-clicked on the string column > 'Remove Errors' (Table.RemoveRowsWithErrors())