How can we improve Power BI?

Quickly remove all columns containing only Null/Blank values

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.

7 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

UKanExcel (Mark Robinson @ Cloud2 Ltd) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Taran Sohal commented  ·   ·  Flag as inappropriate

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

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.