I need to

Load queries into your workbook

You have several options to load queries into your workbook:

From
Search results

From the
Navigator pane

From the
Query Editor

From the
Workbook Queries pane and the contextual
Query ribbon tab

Note: When you click
Load To from the
Workbook Queries pane, you can only
Load to worksheet or
Load to Data Model. Other Load To options allow you to fine-tune how you load a query. To learn the full set of load options, see How to fine-tune your load options.

Fine-tune your load options

With Power Query Load To options, you can

Select how you want to view your data.

Select where the data is loaded.

Add data to the Data Model.

Load a query to the Excel Data Model

Note: The steps in this section require Excel 2013.

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.

Set default query load settings

To set your default query load settings

In the
Power Query ribbon tab, click
Options.

In the
Options dialog box, choose a
Default Query Load Setting.

Note: The Query Editor only appears when you load, edit, or create a new query using Power Query. The following video shows the Query Editor window appearing after editing a query from an Excel workbook. To view the Query Editor without loading or editing an existing workbook query, from the Get External Data section in the Power Query ribbon tab, select From Other Sources > Blank Query. The following video shows one way to display the Query Editor.