Query dependencies

Just joining the blog? Explore prior lessons here.

When you have multiple queries which depend on each other, it's important to understand those connections, especially if you weren't the person who originally wrote the set of queries.

Power Query's Query Dependencies creates a visual map to display how each query is connected to the others.

---

Query Dependencies

To view Query Dependencies, open the Power Query Editor, and on the View menu select "Query Dependencies" on the far right. 

Below is an example of a set of queries. Notice first that the query "Calendar" is not connected to any other query. Then note how the Current Workbook serves as the central source for the remaining displayed queries. The query "Path2" is the foundation for the next queries. If you modified "Path2" it could impact all the queries downstream culminating in to the "Newest Transactions" query which is built from combining all the connected files upstream of it ending in the final query "Working_Budget_Query".

---

In this lesson, you learned how to:

• How to view Query Dependencies; and
• How to interpret the query dependency map.

 

Prior post: A table is not a Table

Next post: Combine all files in a folder, Coming October 25