Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 88

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?

    Correct Answer: B

    To improve the performance of a Power BI report, particularly one with a large dataset and many visuals, it is effective to remove unused columns from tables in the data model. This helps reduce the size and complexity of the data model, thereby increasing efficiency and speeding up the loading times of visuals.

Discussion
BenShirrrr

Deja vu

abbeyabh

I think it is 3rd DejaVu

Richdata23

agreed

ewelaelaOption: B

B is correct almost the same as Question #53, Topic 2

NawabiOption: B

B CORRECT

ZackandCoding

i wish all questions were this easy and straightforward.

nassimanafaOption: B

B is correct

AZFabioOption: B

Flashback

Abhi_1526Option: B

Repeated Question Obviosuly B

Data_WorksOption: C

The correct answer is C. Replace the default visuals with AppSource visuals. The question never mentioned about to reduce the size of the data model. The problem was the visuals taking so long to load. Placing multiple visuals in a single page makes the visuals to slow load. Limiting visuals in a single page makes the visual loading time faster. Reference: https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-optimization#limit-visuals-on-report-pages

user28272615

Was at the exam on February 12th 2024

Igetmyrole

IF & Active Store Name = IF([Status] = "A", [Store Name], "Inactive - " & [Store Name])

IgetmyroleOption: B

B is correct. By removing columns that are not needed for the report, you can reduce the size of the data model. this can lead to faster loading times, especially when dealing with large datasets.

LouStar2

same as Question #53 Topic 2

raniaOption: B

remove unused columns

ShalalehOption: B

Given answer is correct.

RazaTheLegendOption: B

B is correct almost the same as Question #53, Topic 2