nerdexam
Microsoft

DP-500 · Question #47

Users indicate that when they build reports from the data model, the reports take a long time to load. You need to recommend a solution to reduce the load times of the reports. Solution: You…

The correct answer is B. No. Creating a perspective that contains commonly used fields does not directly reduce report load times; perspectives primarily simplify navigation for users by showing a subset of the model.

Implement and manage data models

Question

Users indicate that when they build reports from the data model, the reports take a long time to load. You need to recommend a solution to reduce the load times of the reports. Solution: You recommend creating a perspective that contains the commonly used fields. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(58 responses)
  • A
    19% (11)
  • B
    81% (47)

Why each option

Creating a perspective that contains commonly used fields does not directly reduce report load times; perspectives primarily simplify navigation for users by showing a subset of the model.

AYes

Creating a perspective does not reduce the actual data processed by queries or the size of the data model, which are the main determinants of report load times.

BNoCorrect

Perspectives act as custom views of a data model, allowing users to focus on a relevant subset of tables, columns, and measures. While they improve user experience by reducing model complexity for specific use cases, they do not inherently change the underlying data model's size, query performance, or data refresh logic, which are the primary factors affecting report load times.

Concept tested: Power BI perspectives purpose and limitations

Source: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-perspective-create

Topics

#Data model performance#Report load times#Power BI perspectives#Performance optimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-500 Practice