Skip to main content

Power BI

New

Quickly remove all columns containing only Null/Blank values

Vote (9) Share
UKanExcel (Mark Robinson @ Cloud2 Ltd)'s profile image

UKanExcel (Mark Robinson @ Cloud2 Ltd) on 04 Jan 2019 18:14:16

The recently introduced Column Quality feature in the Query Editor allows us to identify Valid, Error and Empty values in each column.

It would be great if we could quickly and easily remove all columns that only contain Null/Blank values.

I recently had a situation where I'd loaded a table containing 100 or so columns into the Query Editor and I had to manually work through these removing all such columns - which was at least half of them.

Having such a feature avaialble in the Query Editor wold be fantastic, and it may also be useful to have something very similar in the Data View which hides all such columns.

Comments (1)
UKanExcel (Mark Robinson @ Cloud2 Ltd)'s profile image Profile Picture

eee6649d 7f27-41c8-969d-30c9d8dee026 on 05 Jul 2020 23:38:57

RE: Quickly remove all columns containing only Null/Blank values

This sounds really useful, particularly with large datasets where a lot of manual removal may be needed