Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

alwang

Power Query Remove Empty Not Working as the Last Step

Submitted by on ‎08-29-2022 12:47 PM

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)

 

1.png2.png

 

 

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

 

3.png

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎08-30-2022 02:19 AM

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
Frequent Visitor
‎08-30-2022 08:02 AM

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

Idea Statuses