Just wanted to share a small tip in PowerQuery where an extra step is added to your queries even though you might not want it.
In this example I have imported the FactInternetSales from the AdventureWorks database and have filtered it with orderdatekey after a specific date.
Now I just want to check the different product keys and I click the dropdown next to the field name.
If you do not specify a filter but just click OK (the default button) you will get an extra step inserted in the Applied Steps
= Table.SelectRows(#”Filtered Rows”, each true)
Which just means that all rows should be returned from the previous step.
If you press Cancel instead the step won’t be added.
So, keep your queries nice and clean and click Cancel instead of OK and stay querious 🙂
PS – and remember to rename the steps to keep them as explanatory as possible.