Forum Discussion

SantoshKumar's avatar
SantoshKumar
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
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...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
SantoshKumar
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

SantoshKumar , Can you a sample pbix after removing sensitive data.