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

UPDATE:

Report Server uninstalled and installed back on both nodes. Both nodes configured to use both HTTP/80 and HTTPS/443 (same certificates as before). Separately both servers working perfectly on both HTTP and HTTPS connections.

After confirming that each node works as a single-instance RS (didn't check this the first time), I joined them using scale-out deployment and both nodes still work (HTTP as well as HTTPS) without any issue. Connections from HAProxy NLB works as well. My current configuration did no changes in rsreportserver.config so far, only the BackConnectionHostNames registry value is present.

 

I will continue to test and monitor current configuration and will post changes. If no changes are made, I will just mark this post as solution - just reinstall the whole thing. 🙂