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.

Question

Accepted Answer

A. user-defined aggregations User-defined aggregations allow pre-summarized tables to be created within the model, which Power BI can query instead of the large DirectQuery source, significantly reducing query response times. B. automatic aggregation Automatic aggregations intelligently create and manage in-memory aggregations based on common query patterns, offloading queries from the DirectQuery source and speeding up visual rendering for frequently accessed data.

Answer

C. query caching Query caching improves performance for repeated queries by storing results, but it does not fundamentally reduce the execution time of the *initial* query to the data source or for complex, unique queries.

Answer

D. OneLake integration

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 mode

Question

Options

How the community answered

Why each option

Topics

Community Discussion