Forum Discussion
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...
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
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
Hi
So simple and it works great, thanks.
Chris