Forum Discussion
TaylorN
6 years agoHelper I
Paginated Reports not loading
I have a few paginated reports deployed to a premium workspace and have had no issues up until now. This morning, I was supposed to receive a subscription, but did not, so I went to investigate a...
- 6 years agoSo it turns out it’s an issue connecting to the source DB. I’m running a serverless Azure SQL DB with auto pause enabled and it appears that the connection attempt isn’t waking up the server like it should.
So Microsoft’s suggestion is to have another report run just before it, which will fail, then the next one should succeed 😕
I don’t like this option, so I’m just going to change the time the report executes to a little bit later, as there is a data factory pipeline that runs and it starts the instance.
v-easonf-msft
6 years agoCommunity Support
Hi , TaylorN
Please refer to this article:
https://docs.microsoft.com/en-us/power-bi/service-admin-premium-workloads
Best Regards,
Community Support Team _ Eason
TaylorN
6 years agoHelper I
If it was disabled, all paginated reports would fail to run permanently, these are just intermittently not working.
I checked the memory allocation and it’s at 20% so no issues there. I’ve raised a case with Microsoft to investigate.
I checked the memory allocation and it’s at 20% so no issues there. I’ve raised a case with Microsoft to investigate.
- GilbertQ6 years agoSuper UserHi there
How much memory in total has been allocated?
It could be that other datasets have consumed all the available memory?- TaylorN6 years agoHelper I
Hi GilbertQ , it's allocated 20% of a P1, so about 5GB. The report is very small, and I can see that the memory usage for the whole capacity has never gone over 1.5GB.
- GilbertQ6 years agoSuper UserThanks for that, it is really weird that it is not running.
I think having Microsoft look at it is the best way!