Analyzing Data with Microsoft Power BI (legacy) — Question 17

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

Answer options

• A. Increase the number of times that the dataset is refreshed.
• B. Split the visuals onto multiple pages.
• C. Change the imported dataset to DirectQuery.
• D. Implement row-level security (RLS).

Correct answer: B

Explanation

The correct answer is B, as splitting the visuals over multiple pages can help reduce the load time by decreasing the amount of data processed at once. Increasing the refresh frequency (A) does not directly address the loading performance issue. Changing to DirectQuery (C) may introduce other performance concerns, and implementing RLS (D) does not impact the loading speed of visuals.