Forum Discussion
Visualizations intermittently fail to load
Additional information.
We have 2 Report Servers accessed by users through a load balancer.
When I logged on to the server direct and accessed the report using the server name and not the load balanced URL, the report loads fine.
Again, we're not seeing this problem with any other reports, at least, it's not been reported as such.
Would the number of visuals on a report be a possible cause? there are 30 visuals on this dashboard spread across 4 pages.
We have isolated the issue to our Load Balancer (Netscaler).
Removing one of the nodes considerably imrpoved the performance of the reports and all visuals loaded successfully.
This is obviously not an ideal solution and we would like to continue to run a scaled out deployment, so if anyone has suggestions as to why using the netscaler would cause this problem and performance degradation, I'd be grateful.
We use netscaler as well. I have it configure with sticky sessions so a given user session is routed to the same server until the session ends. If your netscaler is randomly throwing requests between the two PBIRS servers it may explain your issue.
We have similar problems. How is your sticky sessions configured? Is it cookie persistence-profile? There are different flavours of it.
