They say that in Excel and PowerBI, if you want a more efficient Data Model or Worksheet you should reduce the number of columns of data.
If you’re familiar with The Query Editor in these apps, you’ve probably seen or used the Remove Columns button. But when it comes to deleting columns, there’s another way – the Choose Columns button.
So what’s the difference? Is it just two ways to do the same thing or is one way better than the other? Watch this video to get the answers you need!
This video assumes that you are familiar with the basics of The Query Editor in Excel and/or Power BI