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 both tables and since few values are of alphanumeric like cac123 etc, i made sure that both ID columns are in Text format.
I was able to apply the Left Outer Join but when i tried to Expand the second table(table2) in the MergedTable , it throws me an error as " Dataformat error: we couldn't convert to number: Details C15810"
Any help is greatly appreciated.
Solved! Go to Solution.
@amitchandak you were right. i took all the steps which i have performed on the data and its look like,
at first the ID column which was in Text format - i have changed it to Numeric and later on i rechanged it agian to Text format.
by removing the wrong step : which is changing the format to numeric, i was able to resolve the issue.
I could say its an Human error but accept your suggestion as a solution for my question.
Thanks again !!
@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.
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!