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.

Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

Have you tried to set the TCP port as 80? Please refer to this detailed post to re-configure your Power BI Report Server and check if the issue is still there.

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello there,

 

I've tried strictly HTTP port 80 configuration (same as your screenshot) and strictly HTTPS port 443 configuration, both of them return the same remote certificate error. Currently I got both 80 an 443 ports configured and the error remains the same (no matter what port I connect to).
Regarding the recommended configuration, mine is pretty much the same. The only difference is that I use domain account to run the service and to connect to database (and two instances in scale-out deployment tab obviously).