Applied steps and undo in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What are Applied Steps in Power BI Query Editor?

Applied Steps are the list of actions you perform on your data in Query Editor. Each step records a change like filtering, renaming, or adding columns. They help you track and modify your data cleaning process easily.

beginner

How can you undo a change in Power BI Query Editor?

You can undo a change by deleting the last Applied Step in the Query Settings pane. This removes the most recent action and reverts your data to the previous state.

intermediate

Why is it important to keep track of Applied Steps?

Tracking Applied Steps helps you understand your data transformation process, makes it easy to fix mistakes, and allows you to update or change steps without starting over.

intermediate

Can you reorder Applied Steps in Power BI Query Editor? Why or why not?

No, you cannot reorder Applied Steps because each step depends on the previous one. Changing the order can break the data transformation logic.

advanced

What happens if you delete an Applied Step in the middle of the list?

Deleting a step in the middle removes that action and all steps after it. Power Query recalculates the data from the remaining steps, so be careful to avoid losing important transformations.

What does an Applied Step represent in Power BI Query Editor?

A A recorded data transformation action

B A saved report page

C A visual chart type

D A data source connection

Applied Steps record each change you make to your data in Query Editor.

How do you undo the last change in Power BI Query Editor?

A Rename the query

B Close and reopen Power BI

C Refresh the data source

D Delete the last Applied Step

Deleting the last Applied Step removes the most recent change.

Can you reorder Applied Steps in Power BI Query Editor?

A Yes, by dragging steps

B No, because steps depend on order

C Yes, by renaming steps

D No, because steps are locked

Applied Steps must stay in order because each depends on the previous.

What happens if you delete an Applied Step in the middle of the list?

A Only that step is removed

B The query refreshes automatically

C All steps after it are also removed

D Nothing changes

Deleting a middle step removes it and all steps after it.

Why is it useful to keep Applied Steps visible?

A To track and edit data transformations easily

B To create new reports

C To connect to new data sources

D To change chart colors

Applied Steps help you track and adjust your data cleaning process.

Explain what Applied Steps are and how they help in Power BI Query Editor.

Think about how each action you do on data is recorded.

Describe the process and effects of undoing an Applied Step in Power BI.

Consider what happens when you remove a step from the list.