Forum Discussion
Helper IRefresh Errors
Thank you for clarifying your requirement. Since management needs reports at a fixed time daily, you could use Azure Data Factory to orchestrate the semantic model refresh, with retries and status monitoring before triggering report delivery.
Please note that Power BI automatically disables scheduled refresh after four consecutive failures and this threshold cannot be changed. An API-driven refresh workflow can provide more control over retries and monitoring, but it cannot guarantee uninterrupted refreshes.
For details, see Microsoft's asynchronous refresh documentation.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
I hope this helps!
Community SupportFollowing up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
Helper IHello! I tested sending the subscriptions out when the dataset changes and I don't know that this will work because our CEO, COO, CIO, and upper managers expect the reports to be in their inbox at a set time every day. For the most part the data does refresh at around the same time but then there were random times where it did not. So, this would not work.
The asynchronous refresh is an interesting concept that I'll need to look into further. It's not anything I've ever tried before. It would be nice if there was a way for me to tell it to refresh daily and never turn off, even if there are failures.
- v-aatheeque
Thank you for clarifying your requirement. Since management needs reports at a fixed time daily, you could use Azure Data Factory to orchestrate the semantic model refresh, with retries and status monitoring before triggering report delivery.
Please note that Power BI automatically disables scheduled refresh after four consecutive failures and this threshold cannot be changed. An API-driven refresh workflow can provide more control over retries and monitoring, but it cannot guarantee uninterrupted refreshes.
For details, see Microsoft's asynchronous refresh documentation.
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
I hope this helps!