CHAPTER 6
Working with Multiple Queries
So far the focus of this book has been on what you can achieve within an individual Power Query query. In many real-world scenarios, however, a single Excel workbook will contain multiple queries connecting to different data sources, and you may want to combine the data from these queries somehow. In this chapter you’ll learn about the various ways you can do this and about some of the data privacy issues that you will encounter when doing this.
Using One Query as a Source for Another
In Chapter 2 you saw how you could use the Reference option to use the output of one query as the data source for another. ...
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.
