Choose Columns v Remove Columns (Query Editor)

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

Introduction

Stop your custom column widths resetting

Prevent end-users getting access to the underlying data

Generate multiple Pivot Tables with a single click

Avoid retyping custom headings when you change the layout

Customize the default settings for future Pivot Tables