Power Query - unable to filter out nulls after Table.NestedJoin (RightOuter)

[Ozeroth]

Hi,

(Sample file here: https://drive.google.com/file/d/0B9pNjpDQKy_LbUctSVJZODhaV28/view?usp=sharing)

I have encountered a possible bug when I follow these steps in Power Query:

1. Merge two tables using Table.NestedJoin with JoinKind.RightOuter
   (in my example I have joined Products & Sales tables, joined on Product column).
2. In the resulting table, as expected, there is a row with null in the Product column (corresponding to rows from Sales with Products that don't appear in the Product table).
3. Then try to filter out the row with null in the Product column using Table.SelectRows.

The problem is that step 3 appears to have no effect: the row with null cannot be filtered out. Even filtering on some other specific value leaves the row with null as well as rows with that specific value.

Can anyone else replicate this? Planning to send a frown.

P.S. I know that using JoinKind.Inner in the first place would have the effect of excluding the Product=null row, but was still bothered by this apparent bug

 

[ImkeF]

Hi Ozeroth,

it is only possible to filter out null after you've expanded the table - so when you only have "simple values" in your table & no "advanced objects" like tables, lists, functions...

No idea if this is a bug or intended behavious actually

 

[Ozeroth]

Hi Imke,

Thanks for that - expanding the nested table column does allow the null to be filtered out.

However, interestingly, if I remove the nested table column, leaving just a column of {A,B,C,null}, I still can't filter out the null.

Anyway, not a biggie. I might submit some feedback.