Question
You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows.
You have a Microsoft Power BI report named Report1 that uses the model. Report1 contains visuals on multiple pages.
You need to reduce the query execution time for the visuals on all the pages.
What are two features that you can use? Each correct answer presents a complete solution.
NOTE: Each correct answer is worth one point.
- A. user-defined aggregations Correct
- B. automatic aggregation Correct
- C. query caching
- D. OneLake integration
Explanation
User-defined aggregations and automatic aggregations both add in-memory aggregation tables on top of DirectQuery tables, so summarized visuals on every page are answered from the cache instead of querying the 500-million-row source. Query caching applies only to Import semantic models and only caches the initial landing page of a report, so it neither works for DirectQuery nor covers all pages. OneLake integration writes Import tables to Delta tables in OneLake and does not speed up DirectQuery visuals.
