Add a query to an Excel worksheet (Power Query)
In Power Query, you have several options to load queries into your workbook. The Options dialog box lets you set default query load settings.
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
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
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 Load To dialog box, check Add the data to the Data Model. To learn how to show the Load To dialog box, see Load queries into your workbook.
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.