CHAPTER 6

image

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

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