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.

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, Power BI for Office 365, Excel 2010