Getting error when I tried apply and close?

[Anonymous]

Hi

I have four tables such as Sales, Product, Manufacturer and Geography.

I created the Sales table by appending two tables such as International Sales and Sales.

International Sales table sample:

Sales Table Sample:

I can able to append these two tables successfully and disabled International Sales. However, when I tried to apply and close, I am getting the below error.

I have converted the zip code into number in both International and Sales tables and appended without any problem in the query editor. However, I am getting the above error when I tried to apply and close. Could you please advise what would be the problem?

[v-lionel-msft]

Hi @Anonymous,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , there can be some space or some character in that. It might have error on that row too. Make the doubt column as text and check

Also, check how to deal with such error

https://www.youtube.com/watch?v=OE6DPmKqN7s

[harshnathani]

Hi @Anonymous ,

One of your numeric Column has a non numeric value. That is why you are getting this error.

Try filtering each of the numeric columns and check.

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi,

Yes, zip column has a text that's what error says. This is very large dataset close to 80 MB. I tried with a filter but unable to see the full preview and can't locate the error. Do you have any other way? 

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Try to use 'Replace Errors' feature.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.