Troubleshoot Power BI Data Refresh Failures
Exhibit
Refer to the exhibit.
```json
{
"refreshSchedule": {
"frequency": "Daily",
"time": "05:00",
"timeZone": "UTC",
"notifyOption": "OnFailure",
"notifyEmail": "admin@contoso.com"
}
}
```Refer to the exhibit. You are configuring a scheduled refresh for a Power BI dataset. The exhibit shows the refresh schedule settings. The dataset is in a workspace in a Premium capacity. The scheduled refresh runs at 5:00 AM UTC daily. However, the refresh is failing consistently. What is the most likely cause?
Quick Answer
An on-premises data gateway is the missing piece here because Power BI's cloud service has no direct network path into a private or on-premises data source, no matter how much capacity backs the workspace. Premium capacity affects how much compute and memory a refresh gets, but it says nothing about network connectivity, so having Premium doesn't solve a connectivity problem -- it only ever affects performance and scale once a connection already exists. When a dataset draws from something like an on-premises SQL Server, Oracle database, or an on-premises SharePoint site, the gateway acts as the bridge that lets the cloud service securely reach into that private network and pull data on schedule. Without that bridge installed and properly configured, every scheduled refresh attempt fails at the connection stage regardless of how correctly the schedule itself, the credentials, or the capacity are set up. This is a useful distinction to internalize generally: refresh failures usually split into two very different categories, connectivity problems, which point to gateway configuration, and authentication or permission problems, which point to credentials. When a scenario mentions a data source that lives outside Microsoft's cloud, especially anything described as on-premises or behind a private network, and refresh is failing consistently rather than intermittently, a missing or misconfigured gateway should be the first thing you check.
⚠ Common exam trap
Candidates often assume Premium capacities automatically resolve connectivity issues or that scheduled refresh is not supported in Premium, when in reality the gateway requirement is independent of capacity tier and depends solely on the data source location.
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
✓
The data source requires a gateway to be configured for refresh.
The exhibit shows a scheduled refresh configured for a dataset in a Premium capacity workspace, but the refresh is failing consistently. The most likely cause is that the data source requires a gateway to be configured for refresh. Even in Premium capacities, if the data source is on-premises or within a private network (e.g., SQL Server, Oracle, or SharePoint on-premises), an on-premises data gateway must be installed and configured to enable the Power BI service to connect and refresh the data. Without a gateway, the scheduled refresh will fail because the cloud service cannot directly access the local data source.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The notify option should be set to 'OnFailureOrSuccess' to get alerts.
Why it's wrong here
Notify option does not cause failure.
- ✓
The data source requires a gateway to be configured for refresh.
Why this is correct
On-premises data sources require a gateway for scheduled refresh, even in Premium.
- ✗
The refresh time is outside the allowed window for Premium capacities.
Why it's wrong here
Premium capacities support scheduled refresh at any time.
- ✗
The dataset is in a Premium capacity, which does not support scheduled refresh.
Why it's wrong here
Premium capacities support scheduled refresh.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 217-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 →
Same concept, more angles
2 more ways this is tested on PL-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Refer to the exhibit. You are configuring a data source in Power BI Service using a JSON policy. The data source fails to refresh. What is the most likely issue?
medium- ✓ A.The service principal does not have permission to the Azure SQL Database.
- B.The version value should be "2.0".
- C.The JSON is missing the 'dataSource' type.
- D.The connection string is missing the database name.
Why A: When using a JSON policy with a service principal in Power BI, the service principal must have the necessary permissions (e.g., db_datareader role) on the Azure SQL Database. Without these permissions, the data source will fail to refresh, as Power BI cannot authenticate or access the data. The JSON policy itself may be syntactically valid, but the underlying authentication fails due to insufficient database-level permissions.
Variation 2. You are connecting to an on-premises Oracle database from Power BI Service. The gateway is installed and configured. However, the scheduled refresh fails with an error indicating that the data source credentials are invalid. Which TWO steps should you take to resolve the issue? (Choose two.)
medium- A.Re-publish the Power BI report from Power BI Desktop.
- ✓ B.Update the data source credentials in the gateway settings in Power BI Service.
- ✓ C.Verify that the gateway machine can connect to the Oracle server and that the Oracle client is installed.
- D.Edit the data source settings in Power BI Desktop and republish.
- E.Reinstall the on-premises data gateway.
Why B: The scheduled refresh failure indicates that the stored credentials for the on-premises Oracle data source in Power BI Service are invalid. You must update the data source credentials in the gateway settings under 'Manage gateways' in Power BI Service to provide a valid username and password that the gateway can use to authenticate against the Oracle database. Option C is correct because the gateway machine requires the Oracle client software (e.g., Oracle Data Access Components or ODP.NET) to be installed and configured, and the gateway must have network connectivity to the Oracle server; verifying these ensures the gateway can reach and authenticate with the database.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 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-300 exam.