DP-500 · Question #58
Based on a query dependency diagram where 'Orders' is load-disabled and dependent queries 'Order Details', 'Customer', 'Shipper' are loaded, when the dataset refreshes, the Orders query will be…
The correct answer is B. 1. Even if a query like 'Orders' is load-disabled, it will be executed once during a dataset refresh if other loaded queries are dependent on it, to provide the data for its dependents.
Question
Options
- A0
- B1
- C3
How the community answered
(43 responses)- A7% (3)
- B91% (39)
- C2% (1)
Why each option
Even if a query like 'Orders' is load-disabled, it will be executed once during a dataset refresh if other loaded queries are dependent on it, to provide the data for its dependents.
The query will be executed because its dependent queries are loaded, even if 'Orders' itself is load-disabled.
When a query is load-disabled in Power Query, its output is not loaded directly into the data model. However, if other loaded queries ('Order Details', 'Customer', 'Shipper') are dependent on the 'Orders' query, 'Orders' must still be executed once to produce the data required by its dependents during the refresh process.
The query will be executed once to produce its result, which is then used by all its dependents; it doesn't execute once per dependent.
Concept tested: Power Query load-disabled queries and dependencies
Source: https://learn.microsoft.com/en-us/power-query/power-query-overview#query-load-behavior
Topics
Community Discussion
No community discussion yet for this question.