Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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!