Problems in Update

[Syndicate_Admin]

Community, Good Day
Over the weekend I had problems with the gateway, so the models were failing when updating and it is well known that after several errors in the update, it is deactivated
This morning I find that I cannot activate the scheduled update and it indicates the following error

It is important to emphasize that this is with some models, this problem did not affect all my models
In addition, it had also happened to me before and there was no problem in reactivating the scheduled update afterwards

If anyone knows what the solution is, I would appreciate it
Thank you very much in advance

Best regards

[Anonymous]

Hi @Syndicate_Admin,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are facing issues reactivating the scheduled refresh for some of your Power BI models after gateway failures over the weekend. Since some models are affected while others are not, we can go through a few troubleshooting steps to resolve the issue.

* Please verify Gateway status if the gateway is online and running properly.

* You can also check credentials of your data source and ensure they are valid.

* Try Manual refresh and If it fails, please check the Refresh History for any error messages and share the details.

* Check if there is any Schema Changes in the dataset which is connected to an external data source.

I would also take a moment to thank @lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real differe

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[Syndicate_Admin]

Good day, I hope you're well

Thank you very much for your answer.

I checked all the steps you suggested and it kept failing, the only solution and the fastest was to delete it from the workspace, repost it and share.

Now, there is a detail that I suppose maybe has something to do with it, There was at one time, maybe last month or before where for a while automatic updates could be scheduled more than 8 times, and I applied it only in those 2 models, now it is no longer possible and I understand, why when I activated the updates and hit apply it indicated the error, When I republish them I only left 8 and saved without problem

It's the only thing I can really think of that could have happened or if you know anything else I'd like to know.

Best regards

[Anonymous]

Hi @Syndicate_Admin,

Regarding your observation about exceeding 8 scheduled refreshes, you're right asPower BI has a limit of 8 refreshes per day for Pro users and 48 refreshes for Premium workspaces. While there was a temporary period where additional refreshes were allowed, this was likely an unintended behavior or part of a temporary service change by Microsoft.

If a dataset was previously configured with more than 8 refreshes, it’s possible that Power BI flagged it as invalid when trying to save the refresh settings under the current limits. Republishing the dataset with only 8 scheduled refreshes would have aligned it with the enforced policy, which explains why it worked afterward. You can always check the dataset’s refresh frequency in Settings the Scheduled Refresh. 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[Anonymous]

Hi @Syndicate_Admin,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[Anonymous]

Hi @Syndicate_Admin,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.

Thank you.

[Anonymous]

Hi @Syndicate_Admin,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Syndicate_Admin]

Hello, hoping you are well

The solution was marked a long time ago, the same day they gave me the solution
As you can see, when you enter you can already see the green box indicating that it is resolved, I don't know if there will be anything else to do.

Best regards

[lbendlin]

What are the data sources?

[Syndicate_Admin]

Nice day
All SQL tables