Reduce rows & cols GOOD PRACTICE in Power Query

When you first use Power Query, you will think the Remove columns & Remove rows are the logical steps, but these are dangerous, as they don't respond well dynamically. There are other features that work better for a number of reasons.
I walk you which attributes of Power Query transformations are bad and which ways you can remove columns & rows more sustainably less likely to break in an error proofed way.

[@alemsisay5875]

Great, thanks for sharing! Came here from one of your other videos, and glad I've watched it.

[@learnspreadsheets]

That’s lovely to read - thanks so much 😃

[@alemsisay5875]

@@learnspreadsheets Thank you 🙂

[@DrivingLessonsnet]

Hi David. Some great tips for making queries more robust. Thanks for sharing. Liked and subscribed. I’ve found that although “choose columns” and “remove other columns” do basically the same thing I prefer to use “remove other columns for two reasons : 1) I can see the data better as I’m scrolling through the columns on screen to visualise what I want to keep 2) the order in which you click in the columns is the order of the results of the step - this then saves me having to do a subsequent reorder step. But as ever in Excel there are generally multiple ways to achieve the same result.

[@learnspreadsheets]

Yes good feedback thanks for that, they do the same thing but the user interface is different, i go between the two!

[@gborka]

Good practice is the best practice. Thank you a lot.

[@learnspreadsheets]

No worries good you find it useful!

[@johnhackwood1568]

Thanks David nice topic to cover

[@learnspreadsheets]

Glad you like it thanks!

[@chandrasekharreddy3617]

Excellent tips, its greatly useful for excel loads.

[@learnspreadsheets]

Glad you think so!