How to Remove Rows in Microsoft EXCEL Power Query

The trick to removing rows during a Power Query import/transform process is to use the COLUMN (text) filter feature. Not hard to do once you know the logic.

Since Power Query is used where continual data refreshing is likely, you MUST do all the data cleanup within the Power Query screen as those actions will be applied during EVERY Refresh. If you clean things up later (when you build your charts/dashboards/grahps etc) those changes will only work until the next data refresh occurs.

My advice is to do as much as you can during the "transform" process while the Power Query screen is active. Saves time/effort in the long run.

[Donparackal]

Thanks a lot David you have explained it in the most simple method from all the other videos available on Youtube

[npcalexa]

Thank you David 🙏🙏🙏🙏⭐⭐⭐⭐⭐ I have spent 2 days for complex formulas and here it is! Just in front of me an so simple 🤦🏼‍♀️🤦🏼‍♀️🤣

[circlecitystacker]

Thank you sir! This saved me a great deal of time 👍

[itzrex]

Tx David great video.
 
Possible to add Parameterization to the Query 

Like need need dynamic search to the extracted data.

For e.g. above the extracted data i will add 1 row, each time i enter new "date" and the extracted data should only provide me the the data as per Parameter enter.

Pls see if u can help

Warm regards,
Sajjad

[canefan]

Can I delete rows from the actual table and have it update the query? Each time I try to delete a row that way, the row comes back when I hit data refresh.

[RohitSingh-nuek]

How can I delete filtered rows in power query.