Load Data

After transformation:

Home → Close & Load

You can load the result into:

  • Worksheet
  • Table
  • Data Model

Load To

Use Close & Load To when you want more control over the destination.

Refresh Queries

When source data changes:

Data → Refresh All

Power Query repeats the saved transformation steps on the updated source.

Important Concept

You don’t need to manually repeat every cleaning operation.

Update Source → Refresh → Updated Result

Practice

Add new sales records to the source file and refresh the query.

PreviousNext