Power Query Remove Empty Not Working as the Last Step

[alwang]

Hello,

Just noticed an anomoly in the Power Query. Not sure if this is for all cases.

When I use "Remove Empty" as my last step in a query, it doesn't work at all (screenshot 1). Even it shows that the null is unchecked in the filter dropdown list (screenshot 2)

I have to repeat the "Remove Empty" one more time, then it works(screenshot 3).

[Anonymous]

Hi @alwang ,

I didn't reproduce your issue, did you select a specific row the first time you chose to remove null values?

Best Regards,
Community Support Team _ Caitlyn

[alwang]

hi, I am certain I am not selecting one row, because I have select the Date column in order to do the filter.

I tried a few more times:

• if I swap the sequence the 2nd last step and 3rd last step (i.e. "Expanded Table"<->"Sorted Rows2"), "remove empty" also works as a last step. 
• If I delete the "Sorted Rows2" step, "Remove Empty" doesn't work if it's as the last step.
• If I delete the "Sorted Rows2" step, "Remove Empty" works if I move it before "Expanded table"

This is really bizzar. As you see, my query has table Merge and Self-join (with index columns), and the [Date] column is a from a expanded list as a result of self join. Neverthless, this shouldn't be a impacting factor for my last few steps. I am performing the "Remove Empty" on the Date column in a simple table.  And it doesn't work.

Thanks