Power BI Streaming Dataset for Real-Time Dashboards from Azure Event Hubs
A data analyst needs to create a real-time dashboard in Power BI that displays streaming data from Azure Event Hubs. The data must be refreshed every second. Which Power BI feature should they use?
Quick Answer
The answer is the Power BI streaming dataset. This feature is the correct choice because it is purpose-built for ingesting and visualizing real-time data with sub-second latency, directly integrating with Azure Event Hubs to refresh dashboards every second without relying on scheduled or query-based refreshes. On the Microsoft Azure Data Fundamentals DP-900 exam, this question tests your understanding of the difference between streaming datasets, push datasets, and import modes—a common trap is confusing streaming datasets with push datasets, but remember that streaming datasets are the only option that supports automatic, continuous refresh from Event Hubs. A helpful memory tip: think of “streaming” as a live video feed, while “push” is like sending a photo album—both deliver data, but only streaming keeps the picture moving in real time.
⚠ Common exam trap
Many candidates confuse DirectQuery with real-time capabilities, but DirectQuery is not designed for sub-second streaming updates and relies on query execution latency, whereas streaming datasets use a push-based model for true real-time refresh.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Streaming dataset
A is correct because Power BI's streaming dataset feature is specifically designed to handle real-time data ingestion and visualization with sub-second latency. It supports direct integration with Azure Event Hubs, allowing the dashboard to refresh every second without the need for scheduled refresh or query-based retrieval.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Streaming dataset
Why this is correct
A streaming dataset pushes data to a Power BI tile in real time without storing it, supporting sub-second refresh from Azure Event Hubs. Import and DirectQuery datasets refresh on schedules or queries, so neither meets the one-second requirement.
- ✗
Import mode with scheduled refresh
Why it's wrong here
Scheduled refresh polls at intervals measured in minutes, so it cannot deliver one-second latency from Event Hubs. Import mode suits periodic batch reporting. Streaming datasets, pushed or automatically refreshed, exist precisely for sub-second event ingestion, making this the wrong feature for the stated requirement.
- ✗
DirectQuery
Why it's wrong here
DirectQuery issues queries against the source on each visual interaction; it does not ingest a continuous event stream, so one-second refresh of Event Hubs data is unattainable. It suits large models needing near-live access to relational sources, not streaming telemetry, which requires a streaming dataset.
- ✗
Power BI Dataflows
Why it's wrong here
Dataflows perform scheduled ETL into Power BI storage, refreshing on a schedule rather than per second, so they cannot surface live Event Hubs telemetry. They are correct for reusable, governed transformation of source data, not for real-time streaming dashboards requiring continuous ingestion.
Go deeper
Related to this question
Learn chapter
DAX Formulas and Measures in Power BI
Key term
Power BI
Power BI is a Microsoft business analytics tool that transforms raw data into interactive visual reports and dashboards for informed decision-making.
Key term
Data ingestion
Data ingestion is the process of moving data from various sources into a storage system where it can be accessed, analyzed, and used.
About these practice questions
Courseiva writes every DP-900 question from scratch — 851 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on DP-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A data analyst needs to create a real-time dashboard in Power BI that refreshes every second from an Azure Stream Analytics job. Which Power BI feature should they use?
easy- A.Scheduled refresh
- ✓ B.Streaming dataset
- C.DirectQuery
- D.Import mode
Why B: B is correct because a streaming dataset in Power BI is designed to ingest real-time data from sources like Azure Stream Analytics and automatically update visuals as new data arrives. This feature supports push-based updates at sub-second intervals, making it ideal for a dashboard that refreshes every second without requiring manual or scheduled refresh cycles.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.