Which two settings should you select?

You have a Power Bl dataset that uses DirectQuery against an Azure SQL database.

Multiple reports use the dataset.

A database administrator reports that too many queries are being sent from Power Bl to the database.

You need to reduce the number of queries sent to the database.

The solution must meet the following requirements:

• DirectQuery must continue to be used.

• Visual interactions in all the reports must remain as they are configured currently.

• Consumers of the reports must only be allowed to apply filters from the Filter pane.

Which two settings should you select? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . Disabling cross highlighting/filtering by default
B . Add a single Apply button to the filter pane to apply changes at once
C . Add an Apply button to each slicer to apply changes when you’re ready
D . Add Apply buttons to all basic filters to apply changes when you’re ready
E . Ignore the Privacy Levels and potentially improve performance

View Answer

Answer: BC

Explanation:

Reduce queries

Reduce the number of queries sent by Power BI using the Query reduction settings. For slicers, select the “Add an Apply button to each slicer to apply changes when you’re ready” option. For filters, select “Add a single Apply button to the filter pane to apply changes at once (preview).”

Reference: https://maqsoftware.com/insights/power-bi-best-practices