Refresh
Rerunning a query's applied steps against the current source data. Robust queries give correct results for data they haven't seen before.
A refresh replays every step, so anything that worked by accident on the first data (a fixed row count, a hard-coded column list, a value position) can fail or silently give wrong results on new data. Robust queries use rules that hold for any data of the same shape.
In the Power Query editor
Home → Refresh Preview in the editor; Data → Refresh All in Excel; Refresh in Power BI Desktop.
Learn more
Practise it
- beginner~7 minFree
Fix a query whose steps point at the wrong step (kite shop)
A step was renamed and the next step still refers to the old name. Repair the chain so the query runs.
- beginner~6 minFree
Remove a leftover step that cuts the data short (kite shop)
A Kept First Rows step left over from testing silently drops orders. Find it and remove it.
- beginner~5 minFree
Return the last step, not an earlier one (kite shop)
The query builds a Line Total column, but the result doesn't show it: the `in` clause returns an earlier step.
- beginner~6 minFree
Fix a Changed Type step that breaks two columns (kite shop)
An automatic type step turned customer names into errors and stripped the zeros from order numbers.