Merge 2 tables: Error DataFormat.Error: We couldn't convert to Number. Details: NA

[srt1111]

Dear members,

Please advice. I have 2 tables in Pbi desktop. I need to compare this 2 tables by its 'Key', which in msExcel i used 'Match'. I need to report out which rows are not matched.

In Power query, i wanted to do the same with using merge queries. However, when i merge the 'key' column from these 2 tables, i encounter error:

DataFormat.Error: We couldn't convert to Number.
Details:
NA

Both columns i have tried changing to 'text' or to ' whole number'. Both will return same error. How to deal with this error?

[zenisekd · Accepted solution]

Hi, my best guess is that there is some value, that is messing up the transformation.
Both columns should be possible to transform to text. I cannot imagine a scenario, when not. As for transforming it to a number, there could be some non-numerical symbol, that doesn't allow the transformation (and in the case of text it won't fit the merge. 

Right now it is difficult to say. Send some sample data, if the transformation to text doesnt work..

[srt1111]

You were right. The original data has at the end of the rows, some note showing information of the downloaded data. It wasnt part of the data, just a note of the file. Remove it and all goes well. Thanks!