Describe Microsoft 365 apps and services →hardMultiple Choice

MS-900 Describe Microsoft 365 apps and services Practice Question

A sales team uses Microsoft Lists to track leads. They want to create a real-time dashboard that shows the number of leads by stage, the total deal value, and the win rate. The dashboard must update automatically when the list is changed. Which Microsoft 365 app should they use to build this dashboard?

⚠ Common exam trap

Many candidates confuse Microsoft Power Automate with a dashboarding tool because it can respond to list changes, but it cannot visualize data; the correct answer requires recognizing that Power BI is the dedicated analytics and visualization app for real-time dashboards.

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

✓

Microsoft Power BI

Microsoft Power BI is the correct choice because it is designed to create real-time, interactive dashboards that can connect directly to Microsoft Lists via the Power BI service or Power BI Desktop. It supports automatic data refresh when the underlying list changes, enabling live tracking of leads by stage, total deal value, and win rate without manual intervention.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✓
Microsoft Power BI
Why this is correct
Microsoft Power BI is correct because Power BI includes a native Microsoft Lists (SharePoint Online) connector that can pull list data into a data model via Power Query. It supports scheduled refresh (up to 8 times per day with a Pro license, or via a gateway in Power BI Report Server) so dashboards can display near-live data without manual intervention. With DAX measures, you can aggregate leads by stage, owner, or time, and build interactive visualizations that update on refresh, making it the only option that combines connectivity, computational analytics, and automatic data refresh.
✗
Microsoft Excel
Why it's wrong here
Microsoft Excel appears tempting because you can import the list data using 'Get Data from SharePoint' and create charts. However, Excel (desktop or web) lacks automatic scheduled refresh from Microsoft Lists; each user must manually click 'Refresh' or write VBA/Office Scripts to re-import data. Even when refreshed, the charts are static graphics within a workbook, not a real-time server-side dashboard, and there is no built-in capability to maintain a live, shared dashboard that updates for all team members simultaneously without additional infrastructure.
✗
Microsoft SharePoint
Why it's wrong here
Microsoft SharePoint can display a Microsoft List in a web part on a page, which gives a live, collapsible view of the raw list data. But SharePoint's native list web parts offer only basic display and simple column filters; they cannot perform cross-list or cross-site aggregation, create calculated KPIs, or build interactive visual analytics beyond a rudimentary chart. SharePoint is the underlying platform that stores Lists, but it is not a business intelligence tool—it lacks the analytical engine (like DAX) and refresh scheduler that Power BI provides.
✗
Microsoft Power Automate
Why it's wrong here
Microsoft Power Automate is a workflow automation service, not a visualization or analytics tool. You could create a flow that triggers when a new lead is added and sends an email or writes a row to another system, but Power Automate has no chart, dashboard, or aggregation canvas. It can move data into Excel or a database that Power BI might then read, but the flow itself cannot render a live lead dashboard, making it functionally incapable of satisfying the reporting requirement.

Go deeper

MS-900 Describe Microsoft 365 apps and services Practice Question

Why each option matters

Option-by-option breakdown

Related to this question