A user wants to create a dashboard that visualizes sales data from multiple sources in real time. Which Microsoft 365 app should they use?
Power BI connects to multiple data sources and refreshes datasets on schedules or via streaming, rendering live dashboards that update without manual intervention. This satisfies the real-time, multi-source visualisation requirement, whereas Excel and Power Apps lack native streaming dashboards across heterogeneous sources.
Why this answer
Power BI is Microsoft's business analytics service that enables users to create interactive dashboards and reports from multiple data sources, with real-time data refresh capabilities. It is designed for data visualization and business intelligence, making it the appropriate tool for this requirement.
Exam trap
MS-900 often tests the distinction between apps for data entry (Forms, Lists) and data visualization (Power BI), and candidates may confuse Excel's charting with Power BI's interactive dashboards.
How to eliminate wrong answers
Option A is wrong because Excel is a spreadsheet application primarily for data analysis and modeling, but it lacks the real-time dashboarding and multi-source connectivity of Power BI. Option B is wrong because Microsoft Lists is for tracking information and managing workflows, not for data visualization. Option C is wrong because Microsoft Forms is for creating surveys and quizzes, not for dashboarding.