Power Query: The *Best* Ways to Remove Columns

In this tutorial you will learn which way of removing columns in Power Query is for 3 different scenarios. It works for both Power BI and Excel.

In this video I am demonstrating three different ways to remove columns in Power Query. They all achieve the same result but each one of them applies best to a different scenario.
This tutorial is useful for beginners and it applies for both Microsoft Power BI and Microsoft Excel.

⌚ TIMESTAMPS
00:00 Intro
00:07 First scenario
00:37 Second scenario
01:12 Third scenario
02:51 Which one should you use?

👍 Thank you for watching! If you found this video helpful or insightful, don't forget to like, comment, and subscribe! Your support means the world. Ready to explore the full potential of Power BI? Remember, you're awesome—catch you later! 🌟 #PowerBI #BIforBeginners #DataMagic #TechTutorial

[qasimali-guoz]

Great video. Let's say I have another scenario of removing empty columns dynamically.

1. Transpoae data
2. Remove empty rows
3.Transpose it back

Another method is the Column.Profile function. This method I have learned from Alejandra Horvath. I am sharing the link in another comment.