Forum Discussion
gonrodrigues
Helper III
Helper IIIDelete 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?...
- 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.
ankitpatira
Community Champion
Community ChampionUnfortunately 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.
gonrodriguesHelper III
Helper IIIThat'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.
- gonrodrigues
Probably the best option, thanks!