Forum Discussion
cw88
2 years agoHelper IV
Subscription error on paginated report
Hi, i set up subscription on a paginated report. The report is based on a sematic model from a fabric warehouse. The subscription ran perfectly on a daily base for the last month. Yesterday i ...
GilbertQ
2 years agoSuper User
Hi cw88
What happens if you try and refresh the semantic model amount? Does it show something and then try and resend the subscription?
cw88
2 years agoHelper IV
Hi GilbertQ ,
resend of the subscription works.
I had the same error "The SQL pool is warming up." at executing procedures on warehouse, for this case the solution was "configure a retry because it can happen that the warehouse needs some time until it is available".
But for the subscriptions there is no option for retry...
- GilbertQ2 years agoSuper User
What I would do is try and create a pipeline to run a SQL query before the subscription runs and see if that works?