CHAPTER 4

image

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.