You’ve got hold of the data you need. You’ve filtered, sorted, aggregated, and otherwise transformed it. Now, the last thing you need to do is decide where the data should end up. Power Query gives you two choices for where the output of a query will be loaded: a table in a worksheet or the Excel Data Model. In this chapter, you will learn how to use both of these destinations and how to refresh a query so your data is up-to-date.
Choosing a Destination for Your Data
When you have finished working in the Query Editor, you can choose a destination for your data using the check boxes in the Load Settings section in the ...