Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 3 Question 68 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 68
Topic #: 3
[All PL-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

DirectQuery: No data is imported or copied into Power BI Desktop.

Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data.

Benefits of using DirectQuery

There are a few benefits to using DirectQuery:

DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation.

Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data.

The 1-GB dataset limitation doesn't apply to DirectQuery.


https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

by Lonna at Jun 11, 2025, 04:30 PM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Queen
5 months ago
15 AppSource visuals? That's a lot! No wonder it's slow.
upvoted 0 times
...
Bulah
5 months ago
I think removing unused columns could help speed things up!
upvoted 0 times
...
Carmela
5 months ago
Really? Changing DAX measures will fix the loading speed? Sounds too simple.
upvoted 0 times
...
Aliza
6 months ago
DirectQuery might not be the best choice for performance.
upvoted 0 times
...
Kenneth
6 months ago
The PBIX file is pretty large at 550 MB.
upvoted 0 times
...
Rickie
6 months ago
I vaguely recall that using iterator functions in DAX can sometimes improve performance, but I'm not confident if that's the right move here.
upvoted 0 times
...
Mignon
6 months ago
I feel like we had a practice question about optimizing visuals, and I think replacing default visuals with AppSource ones might not be the best approach for performance.
upvoted 0 times
...
Blair
7 months ago
I'm not entirely sure, but I think changing to DirectQuery might slow things down even more since it pulls data live, right?
upvoted 0 times
...
Delsie
7 months ago
I remember we discussed how removing unused columns can really help with performance, especially with large datasets like this one.
upvoted 0 times
...
Kristeen
7 months ago
I'm a bit unsure about this one. Changing the DAX measures or replacing the default visuals seem like they might not have a big enough impact. I'm leaning more towards the DirectQuery or removing unused columns options.
upvoted 0 times
...
Talia
7 months ago
Whoa, 550 MB for a Power BI report? That's massive. I'd definitely start by looking at removing any unused columns - that could help trim down the file size and improve performance.
upvoted 0 times
...
Rose
7 months ago
Okay, let's see. The report is slow, the file size is large, and the dataset is refreshed frequently. I'm thinking changing to DirectQuery might be the way to go here.
upvoted 0 times
...
Cordell
7 months ago
Hmm, this looks like a tricky one. I'll need to carefully consider the options and think through the potential impact of each recommendation.
upvoted 0 times
...
Dottie
11 months ago
I think we should also remove unused columns from tables in the data model to further optimize the report.
upvoted 0 times
...
Daron
11 months ago
Wait, they want to improve the performance, not make it look fancier. I'd go with option D as well.
upvoted 0 times
Raul
9 months ago
Definitely, optimizing the data model is key for improving performance.
upvoted 0 times
...
Ryan
10 months ago
That sounds like a good idea. It could help speed up the report.
upvoted 0 times
...
Virgina
10 months ago
Option D) Remove unused columns from tables in the data model.
upvoted 0 times
...
...
Celeste
11 months ago
Replacing the default visuals with AppSource visuals? That's like using a sledgehammer to crack a nut. Doesn't seem like the best solution here.
upvoted 0 times
...
Gertude
11 months ago
I'd go with option D. Cleaning up the data model is usually the first step to optimize a report's performance.
upvoted 0 times
...
Princess
11 months ago
Removing unused columns from the data model sounds like a good idea. That could help reduce the overall size of the PBIX file and improve load times.
upvoted 0 times
Arlette
10 months ago
I agree, it's a good practice to optimize the data model for better performance.
upvoted 0 times
...
Lourdes
10 months ago
Yes, removing unused columns can definitely help with performance.
upvoted 0 times
...
...
Georgeanna
11 months ago
I agree with Naomi. DirectQuery could help improve the performance by querying the data source directly.
upvoted 0 times
...
Naomi
11 months ago
I think we should consider changing the imported dataset to DirectQuery.
upvoted 0 times
...
Cherrie
11 months ago
Hmm, changing the dataset to DirectQuery might help with the performance issues. That way, the data doesn't have to be loaded all at once.
upvoted 0 times
Laurena
10 months ago
D) Remove unused columns from tables in the data model.
upvoted 0 times
...
Nell
10 months ago
C) Change the imported dataset to DirectQuery.
upvoted 0 times
...
Reta
10 months ago
B) Replace the default visuals with AppSource visuals.
upvoted 0 times
...
Lizbeth
11 months ago
A) Change any DAX measures to use iterator functions.
upvoted 0 times
...
...

Save Cancel