What should you recommend?

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?
A . Change any DAX measures to use iterator functions.
B . Replace the default visuals with AppSource visuals.
C . Change the imported dataset to DirectQuery.
D . Remove unused columns from tables in the data model.

View Answer

Answer: C

Explanation:

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.

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