Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |