topic Distributed Deployment: Something went wrong. Please try again later when opening report in Report Server

Distributed Deployment: Something went wrong. Please try again later when opening report

Anonymous — Thu, 08 Aug 2019 13:15:30 GMT

Hi,

We use AuthenticationTypes: RSWindowsNTLM.

Users are facing this error when connecting from Windows workstations, NTLM works fine. There is no issue on Macs.

Here is our setup:

1. Reverse Proxy on top of two nodes:

2. Node1 is running SQL Server DB and Reporting Server PBIRS instance

3. Node2 is running Reporting Server PBIRS instance and connects to database running on Node1.

We are facing this terrible error "Something went wrong. Please try again later" when we keep PBIRS on both nodes started.

Problem doesn't appear when we shutdown one of the PBIRS instances, regardless of node.

How can we troubleshoot this error?

Re: Distributed Deployment: Something went wrong. Please try again later when opening report

d_gosbell — Fri, 09 Aug 2019 04:08:20 GMT

I assume by reverse proxy that this is some sort of load balancer?

If so, did you follow all the documented steps for configuring PBIRS in a load balancer scenario (see https://docs.microsoft.com/en-us/sql/reporting-services/report-server/configure-a-report-server-on-a-network-load-balancing-cluster?view=sql-server-2017)

Specifically check the BackConnectionHostNames settings. If you don't have that set then requests between the various components of PBIRS can "jump" across nodes which causes issues with many operations such as publishing reports.

Re: Distributed Deployment: Something went wrong. Please try again later when opening report

Anonymous — Fri, 09 Aug 2019 08:37:17 GMT

Thanks for pointing this out, for the time being I resolved the issue by reinstalling Power BI software on both nodes.

Right now we are running May-2019 release.