Forum Discussion
Power BI Model Refresh Turning Off
Hi teetoes,
Thank you for your inquiry through the Microsoft Fabric Community Forum.Based on the details of your query, it appears that the issue may be related to the scheduled refresh configuration or the Power BI service itself.
Kindly follow the steps outlined below to troubleshoot and potentially resolve the issue:
- Delete the existing scheduled refresh and create a new one. Please ensure that the scheduled refresh settings are configured correctly.
- Enable email notifications for refresh failures to receive timely updates in the event of a failure.
- Confirm that the service account used for credentials has the required permissions for all relevant data sources and the necessary access rights to the model being refreshed.
- If the dataset is large or complex, consider simplifying or optimising the model to enhance performance and reduce the likelihood of refresh issues.
- Verify that the scheduled refresh time aligns with your local timezone, as discrepancies in timezone settings may cause issues.
- Publish the same PBIX file to a new workspace and configure the scheduled refresh in the new workspace. If it functions correctly in the new workspace, the issue could be related to the configuration of the original workspace.
For additional guidance, please refer to the following resources:
Configure scheduled refresh - Power BI | Microsoft Learn
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
If you find this response helpful, kindly mark it as the accepted solution and give kudos. This will assist other community members facing similar concerns.
Thank you.
Hi, thanks for the response. Here is what I tried:
1. I couldn't remove the old schedule, because Power BI wouldn't hold onto the schedule at all. So I'd set it up, apply it, close out and come back and it would be greyed out again with nothing set up.
2. Email notifications were enabled, but the refreshes never kicked off, so there was never a failure to notify me about and it also didn't notify me that the refresh never occurred.
3. The Service Account has the necessary credentials, as I am able to refresh manually without issue.
4. The dataset is 2G in a Premium Capacity workspace so this shouldn't be a problem, but I moved it to large capacity format.
5. Timezone was set correctly.
6. This is probably what helped me figure out the issue, but it had nothing to do with workspace configuration and everything to do with Power BI caching. I cleared my cache, reloaded, added the schedule and now it's holding. Because it held in another workspace with identical settings, I decided to try the fall-back cache-clearing trick. It worked. Also, that's really not a good look for the service here. I shouldn't have to constantly clear my cache to get settings and permissions and selections to apply and stay applied. Really poor design in my opinion.
Thanks for the assistance. This at least got me to what the cause was and now we are on track. Still no idea why it kicked the schedule out to begin with but it works now.
Hi teetoes,
We are pleased to hear that your issue has been resolved. Kindly mark the response that resolved your issue as the accepted solution and provide kudos. This will help other community members facing similar challenges to find solutions more efficiently.
Please continue using Fabric Community for any help regarding your queries.
Thank you.