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.
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.