Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Scale-out Power BI Report Server behind HAProxy

Hello there,   I'm exploring on-premise scale-out option and I would like to ask for some help. I'm using two Report Server nodes (version January 2021) and database in dedicated AlwaysOn SQL Serve...
ReportServer
scale-out
  • Anonymous's avatar
    Anonymous
    5 years ago

    I've stopped using HAproxy and used Windows Failover Cluster and everything works just fine. As everything worked, I once again removed HTTP configuration and left only the HTTPS, which resulted in following error (when opening a report):

    OData exception occurred: Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.

     

    TL;DR: HTTP configuration should definitelly stay and shouldn't be removed. Since WFC works, I will be using it instead of HAProxy.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Another update: I'm able to open and work with reports when connecting directly to the each Report Server node, but when I open the same reports from HAProxy connection, report is stuch in loading loop and creating multiple headers:

 

I modified default rsreportserver.config once again with the values from original post, but the issue remains.

Once again, any tips about resolving this are welcome.