Applied Steps in Power Query
Applied Steps are the recorded recipe of a Power Query query. Every transform you click becomes a step. On refresh, Power Query replays the list on the latest source data — the Excel file itself stays untouched.
Friends! Students clean once and panic next month. Why? They never named the steps. How? We open a messy FreshBasket sales sheet in Power Query, watch Applied Steps grow, rename them, click back in history, and use the gear to edit. Refresh is just “play the recipe again”.
मित्रांनो! Students एकदा स्वच्छ करतात आणि पुढच्या महिन्याला घाबरतात. का? Steps ला नाव दिलेच नाही. कसे? FreshBasket ची गोंधळाची sheet Power Query मध्ये उघडायची, Applied Steps वाढताना बघायचे, rename, history मध्ये क्लिक, gear ने edit. Refresh म्हणजे “recipe पुन्हा चालवा”.
मित्रों! Students एक बार साफ़ करते हैं और अगले महीने घबराते हैं. क्यों? Steps का नाम रखा ही नहीं. कैसे? FreshBasket की गड़बड़ sheet Power Query में खोलें, Applied Steps बढ़ते देखें, rename, history में क्लिक, gear से edit. Refresh मतलब “recipe फिर चलाओ”.
Quick answer
Vertical path:
- Home → Transform data (Power Query Editor).
- Watch Applied Steps on the right: Source, Navigation, Changed Type…
- Do a clean action (filter blank City) — a new step appears.
- Right-click → Rename the step in plain English.
- Click an older step to see which rows still existed then.
- Close & Apply when the preview looks right.
Real example: blank city rows before totals
Messy import:
| City | Year | Channel | Amount |
|---|---|---|---|
| Mumbai | 2025 | Online | 100 |
| 2025 | Store | 50 | |
| Pune | 2025 | Online | 40 |
Before: three rows. A careless SUM might still be 190, but the blank city breaks slicers and relationships stories.
After you filter out blank City (new Applied Step):
- Rows that stay: Mumbai 100 and Pune 40.
- Row that leaves: the blank-city 50.
- Total becomes 140.
- The step list now shows something like
Removed blank City. - Next month’s refresh runs the same filter on new rows.
Why the step list is the helper: without it you cannot see when the blank disappeared, and you cannot undo just that action safely.
What do I need before this guide?
- Connect Excel/CSV.
- Idea of Power Query vs DAX.
- Course: Applied Steps.
Before and after (look at the tables first)
Before
आधी (Before)
पहले (Before)
After
नंतर (After)
बाद में (After)
Tour of the step list
Every click in Power Query becomes an Applied Step. Refresh replays the list on new data.
Power Query मधील प्रत्येक क्लिक एक Applied Step होतो. Refresh नवीन data वर यादी पुन्हा चालवतो.
Power Query में हर क्लिक एक Applied Step बनता है. Refresh नए data पर सूची फिर चलाता है.
Rename steps like Removed blank rows. Click a middle step to see the table as it was then.
Steps ला Removed blank rows सारखी नावे द्या. मधल्या step वर क्लिक करून तेव्हाची टेबल बघा.
Steps को Removed blank rows जैसे नाम दें. बीच वाले step पर क्लिक कर तब की टेबल देखें.
- Source — where the file or database lives.
- Navigation — which sheet or table you picked.
- Promoted Headers / Changed Type — often automatic.
- Your steps — filters, splits, merges — in order.
- Click any step: the centre preview time-travels to that moment.
The gear icon reopens the dialog for that step. Deleting a middle step can break steps below it.
Gear icon त्या step चा dialog पुन्हा उघडतो. मधला step delete केल्याने खालचे steps तुटू शकतात.
Gear icon उस step का dialog फिर खोलता है. बीच का step delete करने से नीचे के steps टूट सकते हैं.
Why the gear exists: many steps were born from a dialog (filter, split, merge). The gear reopens that dialog so you edit settings without rewriting M by hand.
Safe habits
- Rename every important step.
- After deleting a middle step, click the last step and check for errors.
- Do not fight automatic Changed Type — verify it (next guide: data types).
- Remember: Power Query does not rewrite your Excel file.
Mistakes and calm fixes
| Symptom | Likely cause | Fix |
|---|---|---|
| Error after delete | Later step needed that column | Undo / restore step; fix order |
| Mystery filter | Untitled step | Rename; click preview |
| Source file “changed” | Myth | Only the query recipe changed |
| Refresh differs from preview | Different privacy / file path | Check Data source settings |
Ravindra Bagale's Tip
Interview line: “Applied Steps are the refresh recipe. I rename them and click back in history before I delete anything in the middle.” Got it?
Ravindra Bagale's Tip – मराठी
Interview line: “Applied Steps म्हणजे refresh ची recipe. मी त्यांना rename करतो आणि मध्ये काही delete करण्यापूर्वी history मध्ये मागे क्लिक करतो.” समजलं का?
Ravindra Bagale's Tip – हिंदी
Interview line: “Applied Steps यानी refresh की recipe. मैं उन्हें rename करता हूँ और बीच में कुछ delete करने से पहले history में पीछे क्लिक करता हूँ.” समझ में आया?
Practice task
- Load a small messy sheet.
- Remove blank cities; rename the step.
- Click Source, then your filter step — watch rows appear and disappear.
- Close & Apply and check the total on a card.
Got it? Applied Steps = the recipe refresh plays. Rename them, click history, edit with the gear. Next: data types. Let us go ahead.
समजलं का? Applied Steps = refresh चालवणारी recipe. Rename करा, history क्लिक करा, gear ने edit करा. पुढे: data types. आता पुढे जाऊया.
समझ में आया? Applied Steps = refresh चलाने वाली recipe. Rename करो, history क्लिक करो, gear से edit करो. आगे: data types. अब आगे बढ़ते हैं.
Frequently asked questions
What are Applied Steps?
The recorded list of transformations for a query. Refresh runs them again on the latest source data.
Can I delete a middle step?
Yes, but later steps may break if they needed that column or filter. Check the preview after delete.
Why rename steps?
So you and your teammate can read the recipe six months later without guessing.
Changed Type appeared alone?
Power Query often adds it automatically. Verify PIN codes stayed Text.
Does Power Query change the Excel file?
No. It only records steps and refreshes into the model. The source file stays as it is.
Course lesson?
Applied Steps in Power Query essentials.