DataFormat.Error: We couldn't convert to Number. Happenning when trying to Merge two tables

[omaffud]

I am trying to merge 2 tables and I am getting the error below:

I already added steps on the tables, changing the fields to TEXT but it looks like the error is persisting. I have no idea where that value in the Details is. How can I troubleshoot and find where that error is when merging?

Thanks.

Otavio

[amitchandak]

@omaffud , check the second step, is there a number conversion, where you are getting text value

[omaffud · Accepted solution]

I solved the issue by fixing the column type just after promoting the headers. It looks like changing it later on the process does not work as it should.

[omaffud]

@amitchandak the error is happening when I expand the item details table column. If the error comes from that table, I do not know where it is because the 2 columns, I want to use from that table are in text format, so I do not know why Power BI is trying to convert to numbers.

[amitchandak]

@omaffud , This seems fine. But check the join column datatypes too. and the expected values

[amitchandak]

@omaffud , This seems fine. But check the join column datatypes too. and the expected values