Handling Multiple Columns in Power Query

Choose Columns drop down

In general, you should reduce the number of columns you import via Power Query to the minimum you require. Here is a quick technique to make that a bit easier.

If you are initially importing lots of columns and you are trying to reduce the number, here is an easy way to do that.

On the Home ribbon in the Power Query window, the Choose Columns drop down allows you to go to specific column or to remove columns.

When you select Choose Columns, all the columns are listed. You can untick the columns you don’t want to import and click OK – job done.

This can help speed up the column selection process.


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.