Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Chris Webb
About this chapter
Cite this chapter
Webb, C. (2014). Data Destinations. In: Power Query for Power BI and Excel. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6692-1_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6692-1_4
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6691-4
Online ISBN: 978-1-4302-6692-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)