Eliminate empty columns in datasets with Power Query. ... Add a custom column to the summary table to compare the `Count` and `Null Count` values. ... Power Query : Instantly Remove All Null Columns.