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?
Go to Solution.
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.
View solution in original post
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...)
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.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!