CHAPTER 4
Data Destinations
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 ...
Get Power Query for Power BI and Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
