Removing Unwanted Columns in Power Query: A Quick & Easy Tutorial

In this video, we show you how to remove unwanted columns from your datasets in Power BI or Excel using the Power Query Editor.

Power Query is the engine behind all the data connection and transformations in Power BI. It was originally introduced inside of Excel and is a powerful tool that allows you to clean, shape, and transform your data with ease.

In most datasets we work with, there are unwanted columns that we drop from our queries to speed up our report performances in Power BI. Follow along with this video and you will see that removing columns in Power Query is a quick and easy thing to do.

For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.

About Go Analytics Inc.

We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.

Need help getting started with Power BI? Let's connect!

***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.

[Trippilakshmi]

I like your videos which are simplified and with short duration really helpful

[toastymmo]

I think it needs to be made clear to Remove and not Delete columns. I didn't need many and those such as with Table and Record data and now my visual dashboard went blank with Fix it messages. Removing them in the Columns drop down down by unselecting them is probably the best option.