6.7 Query Dependencies
Large projects have many queries: source queries, staging queries, helper functions, parameters (बदलता येणारे मूल्य, जे अनेक ठिकाणी वापरता येते) and final tables. View › Query Dependencies shows a diagram of how they connect.
Steps in Power BI
- In the Power Query Editor click View › Query Dependencies.
- The diagram shows data sources (files, folders, databases) on the left, then queries, then the tables loaded to the model.
- Select a query to highlight everything it depends on and everything that depends on it.
- Use the layout options and zoom at the bottom of the window to read large diagrams.
Worked example. In our project, the diagram shows: Folder (Blinkit files) → Blinkit_Orders; AmazonNow_Orders.csv → AmazonNow_Orders; both → Orders (loaded); Products.xlsx → Product; and the parameter FolderPath feeding the folder source.
Organise the Queries pane: right-click a query › Move To Group › New Group… and create groups such as Parameters, Staging, Dimensions, Facts, Functions.
Tip
Queries shown in italics in the Queries pane have Enable load turned off – they run but are not loaded into the model.
Ravindra Bagale's Tip
Mitrano, khup students delete a "staging" query that looks unused, and three other queries fail. Check View › Query Dependencies before deleting or renaming any query or parameter. It shows exactly which queries depend on it. He exam aani interview doghansathi important aahe.