Jason Schaeffer on 18 Nov 2020 15:53:11
In Power Query, right-click on a query and choose Create Function. This makes a function whose definition is based on that query, and when the query is edited, the function is automatically updated. I like this.
When I use the Query Dependencies view, it is hard to see which functions depend on which queries for their definition. In my thinking, this is a different kind of dependency, but it is a very important one to know about when deciding to "clean up" your queries, taking out the items that do not have a dependency chain to a query that is used as output from Power Query to Power BI (or Excel).
Even worse, all my functions show as objects having no dependencies, even when I know that they reference other queries in their definition. I can always take a screenshot and draw the relationships in with a Sharpie, but there's no easy way to create a readable screenshot of a realistic set of queries, and the dependency view does not take any care to put the functions near the views they depend on, so it becomes quite hard to read. Plus I can't click on a box in my screenshot and see how the dependency chain interacts with the box of interest.
Please add a differently formatted arrow to the dependency to represent these "defined by" relationships between a function and its defining query.