Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Hoping for some guidance here. I am trying to merge 2 tables together in Power Query using a text field to do the join. When I do an inner join I get an error saying "DataFormat.Error: We couldn't conver to Number. Details: 6/27/2020". No where in either table am I trying to convert a date field to a number so I have no idea where this is coming from. Additionally when I do a left or right join with the same tables I don't get an error.....
Has anyone run into a similar issue.
Thanks
Hi @Anonymous
Kindly change the data type to text. before you do the inner join
I already did that in a previous step..
I'd double check that after the join it's not tried to put in an automatic changed type row first
Any guidance on how I can do that?
When I do to look in the advanced editor for the new query after the merge this is all I can see..
let
Source = Table.NestedJoin(COMBINED_SALES_DATA, {"Commission Customer Number"}, #"Customer Number to ED Agent", {"Customer Number"}, "Customer Number to ED Agent", JoinKind.Inner)
in
Source
and output of the query just shows this
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |