Question 30
An analyst wants a dropdown of valid regions at report consumption time, not a refresh-time source parameter. Which feature is correct?
Explanation
Correct Answer
Use a report slicer over a Region field rather than an M query parameter. Slicers change visual filter context, while Power Query parameters generally shape loaded data.
Incorrect Answers
A parameter centralizes configuration that can change by environment. That matters for “development and production without rewriting every Source step” rather than the condition “report consumption time, not a refresh-time source parameter”.
Those names drive partition-aware time window filtering for incremental refresh. The boundary it addresses is “incremental-refresh configuration uses two specially named datetime boundaries”, while this case concerns “report consumption time, not a refresh-time source parameter”.
A reusable date parameter avoids hard-coded cutoffs scattered across M steps. This solves “a rolling date cutoff used by several queries”; the stated issue is “report consumption time, not a refresh-time source parameter”.