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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.