Paginated Reports not loading

So 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.