PL-300 Prepare the data Practice Question

Answer analysis

Option-by-option breakdown

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

• ✓

  In the Power BI service, configure a scheduled refresh for the dataset with the desired time.

  Why this is correct

  Configuring a scheduled refresh in the Power BI service is the correct approach for a SharePoint Online dataset because the source is a cloud data source. You set the desired time and frequency directly in the dataset settings, and Power BI uses the stored credentials and refresh history to run the operation automatically—no gateway or custom scripting is required. This built-in feature is the simplest, most reliable, and standard method for keeping cloud data fresh.

• ✗

  Use Power Automate to trigger a refresh via the Power BI REST API every morning.

  Why it's wrong here

  While Power Automate can invoke a refresh through the Power BI REST API, this adds unnecessary complexity for a routine daily refresh of a SharePoint Online dataset. You would need to construct an HTTP request, manage service principal authentication or a stored credential, handle throttling and error responses, and schedule the flow separately—each step introducing potential failure points. The Power BI service already provides native scheduled refresh, so the REST API path is only valuable for advanced orchestration, not standard morning refreshes.

• ✗

  Enable incremental refresh for the dataset and set the refresh frequency to daily.

  Why it's wrong here

  Incremental refresh is a performance feature designed to limit the amount of data reloaded by partitioning large datasets (e.g., only new or changed rows since the last refresh). It is irrelevant here because the requirement is simply to refresh the dataset at a specific time, not to optimize refresh speed or reduce load, and enabling it also requires defining RangeStart and RangeEnd parameters and a date column. Setting a 'refresh frequency' is done via the dataset's scheduled refresh settings, not through incremental refresh—so this option conflates two unrelated capabilities.

• ✗

  Install an on-premises data gateway and configure a scheduled refresh.

  Why it's wrong here

  An on-premises data gateway is only necessary when the data source resides on a private network, such as a local SQL Server or on-premises SharePoint Server. Since this scenario explicitly uses SharePoint Online—a cloud service—the Power BI service can connect directly to the data source over the internet using stored credentials, making a gateway unnecessary and potentially a security risk if opened outbound to cloud services. Installing and configuring a gateway would require additional infrastructure, outbound connectivity, and maintenance without providing any benefit for a cloud data source.

Go deeper

Related to this question