I have deployed SSRS-Scale out along with Azure Load balancer. Seems it is working but I see the below error for some executions. Seems Report viewer cache the session along with the user name of local instances in the database and if the successive request goes another instance, it gives an error.
I can avoid this issue by changing the session affinity of azure load balancer (by client IP), but all of my requests will be coming from the same source. How can I solve the issue? Is there a way to remove session caching for the report viewer?