Power QueryExercises

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

Related terms