In DirectQuery mode, which change reduces the number of queries when using filters and slicers?

In DirectQuery mode, which change reduces the number of queries when using filters and slicers?

• A. Add apply buttons to all the basic filters
• B. Add Top N filters to all the visuals
• C. Change default visual interaction from cross highlighting to cross filtering
• D. Enable automatic page refresh for each report page

Answer: (A)

In DirectQuery, every change to a filter or slicer can trigger a separate query to the data source. By adding apply buttons to basic filters, selections are collected and only a single query is sent when you click Apply, reflecting all current choices at once. This batching reduces the total number of queries compared to applying each filter change individually. The other options don’t batch filter changes and can either keep triggering queries per interaction or even increase query activity (for example, automatic page refresh adds more queries).

In DirectQuery, every change to a filter or slicer can trigger a separate query to the data source. By adding apply buttons to basic filters, selections are collected and only a single query is sent when you click Apply, reflecting all current choices at once. This batching reduces the total number of queries compared to applying each filter change individually. The other options don’t batch filter changes and can either keep triggering queries per interaction or even increase query activity (for example, automatic page refresh adds more queries).