PL-300 · Question #403
You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power BI report that meets the following requirements…
The correct answer is A. DirectQuery mode. For a Power BI semantic model connected to a frequently updated streaming source, DirectQuery mode is best for real-time analytics, minimizing source impact, and displaying the most recent data without explicit refreshes.
Question
You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power BI report that meets the following requirements:
- Supports real-time analytics
- Minimizes performance impact on the data source
- Displays the most recent data without performing a data refresh
Which connectivity mode should you use for the dataset?
Options
- ADirectQuery mode
- Bimport mode
- CLiveConnect mode
- Dpush mode
How the community answered
(48 responses)- A81% (39)
- B10% (5)
- C2% (1)
- D6% (3)
Why each option
For a Power BI semantic model connected to a frequently updated streaming source, DirectQuery mode is best for real-time analytics, minimizing source impact, and displaying the most recent data without explicit refreshes.
DirectQuery mode directly queries the underlying data source with every user interaction, ensuring that reports always display the most current data without needing a data refresh in Power BI. This mode minimizes performance impact on the data source as Power BI does not store a copy of the data, only metadata.
Import mode loads all data into the Power BI model, requiring scheduled refreshes to get updated data, which doesn't meet the real-time or 'without data refresh' requirements.
LiveConnect mode connects to existing Power BI datasets or Analysis Services models, not directly to a streaming source for query-based real-time analysis as described.
Push mode programmatically pushes data into Power BI, typically for real-time dashboards, but for a semantic model connecting to a source for query-based real-time analytics, DirectQuery is the standard approach.
Concept tested: Power BI connectivity modes (DirectQuery)
Source: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Community Discussion
No community discussion yet for this question.