cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DAN1980 Regular Visitor
Regular Visitor

left join

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 

 

tables_example.JPG

 

Links attached -

 https://app.powerbi.com/groups/b8d70bb1-560b-4902-9f7c-3a6b339aab9e/reports/cd6cd7bd-3048-420f-8332-...

 

Hope for your responds

 

Dan

 

 

 

6 REPLIES 6
ThomasFoster Established Member
Established Member

Re: left join

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.

DAN1980 Regular Visitor
Regular Visitor

Re: left join

in query editor i have onle

#"Merged Queries1"

#"Expanded ..."

 

I haven't as a change type step

 

Dan

ThomasFoster Established Member
Established Member

Re: left join

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?

DAN1980 Regular Visitor
Regular Visitor

Re: left join

both have a same header .

data type "text"

ThomasFoster Established Member
Established Member

Re: left join

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?

DAN1980 Regular Visitor
Regular Visitor

Re: left join

i tried to sent pbix contain excel files.

however, it is working correct.

I don't have permission share our server data.

 

any idea ?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 149 members 1,867 guests
Please welcome our newest community members: