Add a query to an Excel worksheet

 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:

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

  1. In the Query Settings pane, check Load to data model.

 Note    The Load to data model option is enabled once the download has finished.

Applies to:
Excel 2013, Excel 2010