You are designing an interactive report for a model-driven app. The report will use more than five million records. The query that retrieves data for the report requires more than five minutes to…

The correct answer is A. Power BI. Power BI is purpose-built for large-scale data analytics and can handle millions of records efficiently using DirectQuery or Import modes, and supports long-running data refreshes. Model-driven app Standard dashboards (B) and Interactive dashboards (C) are limited in the volume…

Analyze and visualize data

Question

You are designing an interactive report for a model-driven app. The report will use more than five million records. The query that retrieves data for the report requires more than five minutes to complete. You need to create the report. Which option should you use?

Options

APower BI
BStandard dashboard
CInteractive dashboard

How the community answered

(47 responses)

A
81% (38)
B
6% (3)
C
13% (6)

Explanation

Power BI is purpose-built for large-scale data analytics and can handle millions of records efficiently using DirectQuery or Import modes, and supports long-running data refreshes. Model-driven app Standard dashboards (B) and Interactive dashboards (C) are limited in the volume of data they can process and the time queries can run - they are not designed for 5M+ record datasets or multi-minute query durations. When report requirements exceed the built-in dashboard capabilities of a model-driven app, embedding or linking a Power BI report is the correct architectural choice.

Topics

#Power BI#Reporting#Model-driven apps#Large datasets

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice