Power BI remove columns in query editor

Use the query editor in Power BI to remove unwanted columns. Tidy up your data for better management within Power BI.

00:00 Introduction
00:07 Explaining the Power BI Interface and Relationship Window
01:32 Look at data window
02:30 Remove columns start of process
03:21 Removing a Column / Field
05:00 Applied Steps
05:40 Use Applied Steps to undo previously deleted columns
06:47 Use Navigation to go back in time
07:42 Use Close and Apply to update editor
09:06 Conclusion mentioning Power Query

#computertutoring

😊 Check out my website and social media to keep up to date - enjoy learning 😊

[JeffnSoanlys]

do you get to the point? I'm typing this as I am waiting, waiting, waiting....Oh, here we are at 2 minutes and you're starting to address the topic. Wait now you are masplaining the columns. oh 3.5 minutes in. There it is. That's all I needed. A nine minute video to get to a 20 second point. I'm out by 4 minutes, don't care what the rest is. I only tuned in for the "to remove columns in query editor." Thanks for posting but please Stay on topic!

[soumrock]

I have a table with 100 columns, where I need only around 8-10. Do I need to select all the unnecessary columns individually and remove them or can it be done all at once. The same thing I need to do for 50 tables, so it is really a pain if no mass selection option is available

[elenitheodosiou]

how do i also remove the column created, after the transfer to another workbook if i pick a single cell?

[kabis]

Great video but the music makes it really hard to concentrate on what you are saying.