Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

There is a bug in FullOuter and RightOuter Join mode!

Just do that code and see both 1 and 2 steps.

In step 1. you can see 2 values in ww Table instead of 1 (which you can see in Source step. 

In step 2. you can still see row with null valiues, despite the filter for not null values.

That's a relation - fundamental function for data handling, please fix the bug urgently!



    Source = Table.NestedJoin(Table.Buffer(#table(type table [k = number, w = text], {{1, "w"}, {2, "w"}})), {"k"}, Table.Buffer(#table(type table [k = number, w = text], {{2, "k"}, {4, "w"}})), {"k"}, "ww", JoinKind.FullOuter),
    #"1.Zombie Values if filter Null" = Table.SelectRows(Source, each ([w] = null)), 
    #"2.Zombie Null Rows when filter not null" = Table.SelectRows(Source, each ([w] <> null))
    #"2.Zombie Null Rows when filter not null"



Status: New
Community Support



You may try to change it as follows.

Source = Table.Buffer(Table.NestedJoin
Frequent Visitor

I can do Table.AddIndexColumn, but please could you say when you fix the bug?


And could you say why Table.AddIndexColumn solves the problem? I understand why Table.Buffer does that, but not undestand why Table.AddIndexColumn helps.