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,
I have big issue with Merging Queries function (power query ).
I have 2 tables:
1.Table A => Fact table
2.Table B => Duplicate from Fact table
I join by left outer join from Table B into Table A. (Table A is the left table)
as you can see in table B the numbers sort from A-Z
however , After merge to Table A their is mess with the numbers.
In the bottom line I want to join Table C to A
Links attached -
Hope for your responds
Dan
In the first line it is sorting alpahbetically, in the second it is sorting numerically. My guess is that there has been a type change that was automatically done that changed the column from a text column to a number. This should appear as a change type step in the query editor.
in query editor i have onle
#"Merged Queries1"
#"Expanded ..."
I haven't as a change type step
Dan
The other possibility is that in the first line you have a different column name to the second, are both these columns the same data type?
How are these columns constructed?
both have a same header .
data type "text"
Ok I cant suggest anything else without having a copy of the pbix file. Are you able to share the pbix, or a similar one that exhibits the same behaviour?
i tried to sent pbix contain excel files.
however, it is working correct.
I don't have permission share our server data.
any idea ?
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |