PL-900 Practice Question: Describe the business value of Microsoft Power Platform
A non-profit organization needs to generate weekly donation reports from multiple data sources and share them with stakeholders via email. Which Power Platform tool should they use to create the report?
⚠ Common exam trap
Many exam-takers confuse Power Automate's ability to send emails with the requirement to create a report, overlooking that Power Automate cannot generate visual data reports—it only triggers actions based on data.
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
✓
Power BI
Power BI is the correct tool because it is designed specifically for data visualization and reporting. It can connect to multiple data sources, transform and model the data, and create interactive reports. These reports can then be scheduled to refresh and be shared with stakeholders via email using Power BI's subscription feature or by integrating with Power Automate.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Power Automate
Why it's wrong here
Power Automate orchestrates workflows and can email outputs, but constructing the aggregated multi-source report itself requires Power BI's data modelling and visualisation. Power Automate is correct for triggering actions or moving data between services, not for authoring the report content.
- ✓
Power BI
Why this is correct
Power BI connects to multiple data sources, models donations, and schedules refreshed reports distributed by email subscription to stakeholders. This satisfies the weekly, multi-source reporting requirement, whereas Power Apps and Power Automate do not deliver analytical reporting.
- ✗
Power Apps
Why it's wrong here
Power Apps builds interactive canvas or model-driven applications for data entry and user interaction; it does not schedule recurring multi-source reports or email them automatically. Power Apps suits scenarios needing a custom UI over data, not the weekly stakeholder distribution described.
- ✗
Power Virtual Agents
Why it's wrong here
Power Virtual Agents creates conversational chatbots for handling user queries; it cannot aggregate data from multiple sources into a scheduled report. Chatbots are correct when the requirement is automated conversational support, not recurring donation reporting delivered by email to stakeholders.
Go deeper
Related to this question
About these practice questions
One of 701 original PL-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-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 PL-900 exam.