Power BI scheduled refresh may be disabled when one or more data sources used by a semantic model are missing valid credentials. This guide explains how to identify the affected data source, update credentials in Power BI Service, resolve common gateway and permission issues, and verify that scheduled refresh is working again.
The Power BI Scheduled Refresh Disabled Error
You may encounter this message when a Power BI semantic model fails to refresh:
Scheduled refresh is disabled because at least one data source is missing credentials.
Power BI requires valid authentication details for every data source involved in a scheduled refresh. If credentials are missing, expired, invalid, or cannot be used to access the source, the refresh may fail and scheduled refresh may be disabled.
Common causes
- Data source credentials have not been configured.
- Saved credentials have expired or are no longer valid.
- The authentication method is incorrect.
- The account no longer has access to the data source.
- An on-premises data gateway is unavailable or misconfigured.
- A data source connection has changed.
- A Power Query query or source connection has an error.
How to Fix Power BI Scheduled Refresh Disabled
Update the affected data source credentials in Power BI Service, resolve any gateway or permission issue, and then reactivate scheduled refresh. Power BI can also deactivate a schedule after four consecutive failures or an unrecoverable configuration error.
Step 1: Open the Power BI workspace
- Sign in to Power BI Service.
- Open the workspace containing the semantic model.
- Locate the semantic model associated with the report.
- Open its settings.
The exact menu labels may vary with the current Power BI Service interface.
Step 2: Open semantic model settings
Open the semantic model settings and locate the section for data source credentials. Depending on the connection type, the available settings may include data source credentials, gateway and cloud connections, or related connection configuration.
Step 3: Update the data source credentials
Review the configured data sources and identify the one with missing or invalid credentials.
- Select the option to edit credentials.
- Choose the appropriate authentication method.
- Enter valid credentials.
- Save the changes.
Repeat the process for every affected data source.
Security note: Use the authentication method required by the source. Never place passwords, access tokens, or connection secrets in blog posts, screenshots, or public repositories.
Step 4: Reactivate scheduled refresh
- Return to the semantic model settings.
- Open the scheduled refresh configuration.
- Check whether scheduled refresh is disabled.
- Reactivate scheduled refresh.
- Confirm the configured refresh frequency and time.
Step 5: Run a manual refresh
Start a manual refresh of the semantic model and review the refresh history. If the refresh succeeds, confirm that scheduled refresh is enabled and that the next scheduled run is configured correctly.
Why Power BI Data Source Credentials Are Greyed Out
If credentials are greyed out, check whether the semantic model uses an on-premises data gateway managed by an administrator. In that setup, the gateway administrator manages the data source credentials. Otherwise, check the semantic model owner, connection configuration, and any Power Query or permission errors.
Troubleshoot Power BI Gateway Issues
If the credentials are valid but the refresh continues to fail, the issue may involve an on-premises data gateway.
- Confirm that the gateway is online.
- Verify that the semantic model is mapped to the correct gateway.
- Check that the configured data source matches the report connection.
- Confirm that the gateway can reach the database or other source.
- Review refresh history for gateway-specific errors.
Power BI Desktop refresh succeeds but Service refresh fails
A successful refresh in Power BI Desktop does not necessarily guarantee that scheduled refresh will work in Power BI Service. Power BI Service may use a different authentication context, gateway configuration, or stored credential configuration. Check the Service connection settings and gateway mapping instead of assuming that the Desktop configuration is sufficient.
How to Verify Scheduled Refresh Is Working
After updating credentials, run a manual refresh and inspect the refresh history. A successful manual refresh confirms that the semantic model was able to retrieve data using the current configuration.
- All affected data source credentials have been updated.
- The semantic model is connected to the correct data sources.
- The gateway is online, if required.
- The manual refresh completes successfully.
- Scheduled refresh is enabled.
- The next scheduled refresh is configured correctly.
- The refresh history shows no new credential errors.
Frequently Asked Questions
Why is Power BI scheduled refresh disabled?
Power BI scheduled refresh may be disabled because one or more data sources are missing valid credentials. Other connection, authentication, permission, or gateway issues can also cause refresh failures.
How do I fix missing credentials in Power BI?
Open the semantic model settings in Power BI Service, locate the data source credentials configuration, and update the credentials for the affected sources. Then run a manual refresh and reactivate scheduled refresh if necessary.
Why are data source credentials greyed out in Power BI?
Credentials may be unavailable for editing because the semantic model or its underlying connections have an issue. Check Power BI Desktop, review Power Query errors and data source permissions, resolve the problem, and publish the report again.
What if Power BI Desktop refresh works but Power BI Service refresh fails?
Review the Power BI Service credentials, gateway configuration, authentication method, and source permissions. The Service may use a different connection or authentication context from Power BI Desktop.
Conclusion
The “Scheduled refresh is disabled because at least one data source is missing credentials” error is commonly resolved by updating the affected data source credentials in Power BI Service and reactivating scheduled refresh.
If the credentials cannot be edited or the refresh continues to fail, check Power BI Desktop, data source permissions, gateway connectivity, and authentication configuration to identify the underlying issue.
Related guide: Run a Power BI report as a different user to test report access and row-level security scenarios.
Explore AzureOps: If you are migrating enterprise reporting workloads, learn more about the SSRS Reports Migration Wizard.
Kunal Rathi
With over 15 years of experience in data engineering and analytics, I've assisted countless clients in gaining valuable insights from their data. As a dedicated supporter of Data, Cloud and DevOps, I'm excited to connect with individuals who share my passion for this field. If my work resonates with you, we can talk and collaborate.
