PL-900 Practice Question: Describe the business value of Microsoft Power Platform
A company uses Power BI to analyze customer feedback from surveys. The data is stored in Excel on SharePoint. They want to refresh the report daily without manual intervention. Which feature should they use?
⚠ Common exam trap
A common mix-up: candidates confuse the on-premises data gateway (needed for local data sources) with the cloud-based scheduled refresh (needed for cloud data sources like SharePoint), or they overcomplicate the solution by choosing Power Automate when the built-in feature is sufficient.
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 scheduled refresh
Power BI scheduled refresh allows you to configure automatic, recurring data refreshes for datasets stored in the cloud (including Excel files on SharePoint). This eliminates the need for manual intervention by using the Power BI service to re-import the data at defined intervals, such as daily.
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 BI gateway
Why it's wrong here
A gateway bridges on-premises data sources to the Power BI service; SharePoint Online is cloud-hosted, so no gateway is needed. It is tempting because gateways enable scheduled refresh, but the correct feature is simply scheduling refresh on the semantic model itself.
- ✗
DirectQuery mode
Why it's wrong here
DirectQuery issues live queries against the source rather than storing imported data, and Excel on SharePoint is not a supported DirectQuery source. It is tempting when real-time data is required, but scheduled refresh of an imported model satisfies this daily-refresh scenario.
- ✓
Power BI scheduled refresh
Why this is correct
Scheduled refresh lets the dataset connect to the Excel file on SharePoint and reload it automatically at defined times, removing manual intervention. The on-premises data gateway is only needed if the source sits behind a firewall, which SharePoint does not.
- ✗
Power Automate flow to refresh the dataset
Why it's wrong here
A Power Automate flow can trigger a dataset refresh through the Power BI connector, but scheduled refresh configured directly on the dataset already performs this daily without manual intervention, so the flow adds an unnecessary component. Power Automate suits triggering actions from events such as a new SharePoint file.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 701-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.