Forum Discussion
DataFormat.Error: We couldn't convert to Number. Happenning when trying to Merge two tables
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
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.
5 Replies
omaffud , check the second step, is there a number conversion, where you are getting text value
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.
omaffud , This seems fine. But check the join column datatypes too. and the expected values
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.
