Data Destinations
Chris Webb · Apress eBooks · 2014
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.