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. ...