Subdomain 1.1: Get or connect to data
1.A report team publishes a semantic model that uses DirectQuery against a Fabric warehouse. Report viewers must be able to filter one particular visual by product category, and the team wants each viewer's category selection to be pushed into the native query sent to the warehouse rather than filtering client-side after all categories are returned. Which capability should the team configure to achieve this?
- A.A dynamic M query parameter bound to a slicer, so the report-level filter value is passed into the Power Query source query at evaluation time.
- B.A calculated column on the fact table that concatenates every category name so the filter can be applied after all rows load into memory.
- C.A hierarchy built from the category and subcategory columns, since hierarchies always fold their filter context to the DirectQuery source.
- D.A bookmark that stores the currently selected category so the same rows are cached and reused on every subsequent report visit.
Show answer & explanation
Correct answer: A — A dynamic M query parameter bound to a slicer, so the report-level filter value is passed into the Power Query source query at evaluation time.
- A. Dynamic M query parameters let a report-level filter or slicer selection be passed directly into a Power Query parameter used inside the DirectQuery source expression, so the resulting native query is filtered at the source rather than downloading unfiltered data.
- B. A calculated column on a DirectQuery table is evaluated in the source's native query language with real limitations, and concatenating category names does not push a viewer's runtime selection into the query; it does not achieve source-level filtering by itself.
- C. A hierarchy is a navigational grouping of columns for drill-down in visuals; it does not by itself cause a viewer's filter selection to fold into the DirectQuery source query the way a dynamic M parameter does.
- D. A bookmark captures the state of filters, slicers, and visual selections for later recall by the same or other users; it does not translate a live selection into a parameterized native query sent to the source.