Error
Last refresh failed: 9/4/2023, 2:11:28 PM
Scheduled refresh has been disabled.
Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset’s settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Solution
Follow the below steps to fix the above error.
1. Open the workspace containing the report dataset and click the elips […] icon next to the dataset name. Click on Settings, as shown in the below image.
2. You may need to take over the ownership of the dataset to edit the data source credentials.
3. Expand the data source credentials section and set all credentials.
In case the Data Source Credentials are Greyed out and are not editable in the Power BI service.
- Check if your PowerBI report has any issues using the PowerBI desktop. You can check the Power Query editor to see if any query has errors or warnings.
- You may have a broken data source connection.
- Check the data source permissions and make sure you have necessary permissions to access the data sources.
Fix the problem and publish the report once again. Now the data source credentials should be editable in Power BI service.
Above steps should resolve ‘Scheduled refresh is disabled’ issue in Power BI dataset in Power BI service.
Pro tips:
1. If you want to test RLS in Power BI or run Power BI report as a different user in Power BI service, you can follow this article.
See more
Kunal Rathi
With over a decade 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.
I am always interested in new challenges so if you need consulting help, reach me at kunalrathi55@gmail.com.