Forum Discussion
Solved
Dataformat error: we couldn't convert to Number issue
Hi , I am trying to Left Outer Join the two excel data here. -> lets say Table1, Table2. Below is my condition: Left Outer (All from first, matching from Second) I have used ID coumns from the...
SantoshKumar , with this error, it seems like still in one of the tables, the data type is not text. Make sure you have changed it in correct table. Or there is transformation post that causing it
SantoshKumar , with this error, it seems like still in one of the tables, the data type is not text. Make sure you have changed it in correct table. Or there is transformation post that causing it
amitchandak Yes , i have crossed checked the data type on the both tables and amde sure both are text before merging them. looking for any alternate solutions to solve the issue.
SantoshKumar , Can you a sample pbix after removing sensitive data.