Question

You manage a composite semantic model that combines a DirectQuery connection to a multi-billion-row fact table in a Fabric warehouse with several imported dimension tables. Users report that high-level dashboard visuals showing yearly and monthly revenue totals are slow because every query hits the warehouse. Detailed drill-through visuals at the transaction level are used rarely but must remain fully accurate. What should you implement to improve the performance of the aggregated visuals while preserving detail-level accuracy?

Accepted Answer

Configure a user-defined aggregation table imported at the month/year grain and map it to the DirectQuery fact table so summary queries hit the cache and fall back to DirectQuery for detail.

Answer

Switch the entire model to Import mode by loading the full fact table into memory to eliminate all DirectQuery round trips.

Answer

Convert the dimension tables to DirectQuery so all tables share a single storage mode and the query engine can fold aggregations.

Answer

Enable automatic page refresh on the dashboard so cached results are served between refresh intervals.