UKanExcel (Mark Robinson @ Cloud2 Ltd) on 2019-01-04 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 (5)
- Merged Idea (3)
Power BI User on 2020-07-03 17:26:43
remove blank "columns" power bi
Include remove blank columns power bi button, similar to Remove Blank Rows. Workarounds with transpose, romove blank rows and transpose, do not work if you have columns names.
Peter Johnson on 2020-12-03 07:45:32
Remove empty columns
Can we please a button to remove all the empty columns in a table? Sometimes, particularly when using new data sources, you don't exactly what columns you might need and some tables have hundreds of columns so it would be nice to be able to delete all the empty columns in one shot
Leonardo Elmor on 2020-12-03 15:45:08