BenchMark Quizzes by MDFT Pro

Optimize Power BI Report Performance With Large Transactions Table

You are creating a report of financial transactions at MDFT Pro showing monthly trends. The source transaction table has over 10 million rows, and the academy needs to ensure reports remain responsive for users.

How can you optimize the report’s performance and provide a smooth user experience?

Choose all correct answers from the options below.

Explanations for each answer:

Create a summary table in the data source with the transaction data grouped by month. is correct. Summarizing data at the source reduces the number of records in the dataset, improving performance.
If you do not create a summary table, set the Storage mode on the transactions table to DirectQuery. is correct. DirectQuery avoids importing all records into the model and queries the database on demand.
If you do not create a summary table, set the Storage mode on the transactions table to Import. is incorrect. Importing all transactions increases model size and refresh time.
Create all visualizations on a single report page. is incorrect. Reducing the number of visuals per page is better for performance than putting all visuals on one page.

Learn more about optimizing large datasets in Power BI:

Power BI Performance Optimization

Exam Preparation Quiz

Optimize Power BI Report Performance With Large Transactions Table