Note When you insert or delete an intermediate step in a query you might potentially break a query. Power Query will display an Insert Step warning when you try to insert a new step.
I want to
Add a query to a Worksheet
In the Query Settings pane:
- Check Load to worksheet (default). Uncheck to disable auto-load to worksheet.
Load a query to the Excel Data Model
An Excel Data Model is a relational data source composed from multiple tables inside an Excel workbook. Within Excel, a Data Model is used transparently, providing tabular data used in PivotTables, PivotCharts, and Power View reports.
With Power Query, data and annotations on the Data Model are preserved when modifying the Load to Worksheet setting of a query. Power Query does not reset the query results in both the worksheet and the Data Model when modifying either one of the two load settings.
To load a query to the Excel Data Model
- In the Query Settings pane, check Load to data model.
Note The Load to data model option is enabled once the download has finished.