Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@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.
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.
Probably the best option, thanks!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |