Unable to publish report to RS

rsmccall33 — Fri, 05 Jan 2018 15:17:05 GMT

PowerBi Report Server version 14.0.600.438 running on Windows 2012 R2

SQL running on another network server

PowerBi Desktop October 2017 on terminal server

When attempting to save a report to the RS, during the save process, an error comes up saying, "An error occurred while attempting to save the repot to PowerBI Report Server."

Error from the RSPortal log:

RSPortal!library!RSPortal.exe!3!01/05/2018-08:48:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/blanktest.pbix' cannot be found.;

Error from the RSPowerBI log:

|ERROR|7|Failed to connect to AS| RequestID = s_2e62a7ce-7150-4f7d-ab39-dc8dc7484a08 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to connect to AS ---> Microsoft.AnalysisServices.ConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:5132

|ERROR|7|Failure in reportproperties| RequestID = s_2e62a7ce-7150-4f7d-ab39-dc8dc7484a08 Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to connect to AS ---> Microsoft.AnalysisServices.ConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:5132

|ERROR|4|Getting list of expired modelsMicrosoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:5132

The PowerBI RS service is running under a domain account, which differs from the domain account that is running the AS service. Both are permitted to Log on as a service.

Re: Unable to publish report to RS

rsmccall33 — Fri, 05 Jan 2018 16:38:52 GMT

It was something dumb. I added the pbi service account to the local admins group, but found it was removed by policy. I added the account to the controlling policy, stopped/started the pbi service and all is well...

topic Re: Unable to publish report to RS in Report Server

Unable to publish report to RS

Re: Unable to publish report to RS