Forum Discussion
Solved
Delete columns with blank/null values
I'm completely new in Power BI and not a master in computers. I have a big DB and a lot of columns have 0 values or are simply blank. How can i delete them all without having to select one at a time?
Thanks!
- Unfortunately there is no button that will remove all columns from dataset that are empty. There is button to remove empty rows but not all empty columns. You will have to do them manually by selecting each column, right click, delete.
gonrodrigues Another option is to do this on the DB side. Just create a query instead of importing the whole table, and remove the column name from the query. Load only those columns you want.
5 Replies
- Unfortunately there is no button that will remove all columns from dataset that are empty. There is button to remove empty rows but not all empty columns. You will have to do them manually by selecting each column, right click, delete.
There is a button to swap rows and columns, so you could do that, delete the empty rows(originally empty columns), then swap back
That's painful.
Thanks!
gonrodrigues Another option is to do this on the DB side. Just create a query instead of importing the whole table, and remove the column name from the query. Load only those columns you want.
