Courses / Power Query (Get & Transform)
18. Refresh and Load To (Close & Load)
Loading query results back to a worksheet or the data model and how to refresh loaded queries.
Power Query M / Excel (Power Query)
Refresh and Load To (Close & Load)
"Load To" decides whether a query's results go into a worksheet, the Excel Data Model, both, or only create a background connection; "Refresh" pulls updated source data into whatever was loaded.
"I refreshed my source CSV but the worksheet didn't change — what did I miss?"
"Close & Load" (Load To) controls where Power Query places query results: a worksheet table, the workbook's Data Model, both, or only a connection; refreshing updates those loaded results from the original data source.
"I refreshed my source CSV but the worksheet didn't change — what did I miss?"
"Close & Load" (Load To) controls where Power Query places query results: a worksheet table, the workbook's Data Model, both, or only a connection; refreshing updates those loaded results from the original data source.