Forum Discussion
Remove Blank Columns
Hello How can I remove blank columns in Power BI Power Query Editor. I have a report that returns columns with nothing in. I can't select columns and remove selected, as future runs of the source ...
In Power Query, go to the Transform tab. Then select Transpose (Top-left of screen)
Then back to the Home tab and select Remove Rows > Remove Blank Rows (these blank rows were your blank columns prior to transposing)
Finally Transform > Transpose once more.
Anonymous , filter value <> null
Hi amitchandak
Thank you, but...
Is this an Applied Step or an option in Power Query Editor?
Will this filter out any blank cell or only columns that have no data with the exception of a Column name?