Forum Discussion
Error when deploying a report to Power BI Report Server October 2017
Hi guys,
so we this weird problem when trying to deploy a Power BI report from Power BI Desktop (October 2017) to Power BI Report Server after upgrading from the June release to the October release of both PBI Report Server and PBI Desktop.
The error message is the following when deploying from PBI Desktop: An error occured while attempting to save the report to Power BI Report Server
It seems we are not the only ones having this problem after looking at this forum. The thing is, after looking at the logs it seems that our problem is not the same as others are having. It seems related to the new AS "instance" that the report server is now hosting. You can see the error log that we get just after getting the error:
RSPowerBI... log:
2017-11-14 15:19:23.1209|INFO|31|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_e9d2d26d-87ef-474f-98b6-e7d2ca0e73b5 2017-11-14 15:19:23.1209|INFO|31|CFG : EnableCustomVisuals = [True] (env) 2017-11-14 15:19:25.1678|ERROR|31|Failed to connect to AS| RequestID = s_e9d2d26d-87ef-474f-98b6-e7d2ca0e73b5 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 [::1]:5132 at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) --- End of inner exception stack trace --- at Microsoft.AnalysisServices.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded) at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString, String sessionId, ObjectExpansion expansionType) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout) --- End of inner exception stack trace --- 2017-11-14 15:19:25.1678|ERROR|31|Failure in reportproperties| RequestID = s_e9d2d26d-87ef-474f-98b6-e7d2ca0e73b5 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 [::1]:5132 at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) --- End of inner exception stack trace --- at Microsoft.AnalysisServices.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded) at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString, String sessionId, ObjectExpansion expansionType) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout) --- End of inner exception stack trace --- at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<LoadDatabaseAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PBIX.DataModelDataSourceProvider.<RetrieveEmbeddedDataSourcesAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<ShredWithModel>d__7b.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<ShredFromPreshreddedFiles>d__51.MoveNext() 2017-11-14 15:19:25.1678|INFO|31|Sending response. Response code NT SERVICE\PowerBIReportServer 400, Elapsed time 0:00:02.0466683| RequestID = s_e9d2d26d-87ef-474f-98b6-e7d2ca0e73b5
Any suggestions to fix this?
9 Replies
- v-qiuyu-msftCommunity Support
Hi jcabgz,
1. Please try to use Upload button in web portal to publish reports to see if the same error throws out.
2. Please restart the Power BI report server service.
Best Regards,
Qiuyun Yu- jcabgzRegular Visitor
Hi Qiuyun,
Thanks for your answer. Here you have the info you requested:
1. I tried this and also got an error. The error message is different though: "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file.". A similar message pops up in the log files, like when deploying from PBI Desktop, related to AS:
2017-11-16 11:21:15.2343|INFO|235|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_c821fe83-856a-44af-91b8-71dfa25531bd 2017-11-16 11:21:15.2343|INFO|235|CFG : EnableCustomVisuals = [True] (env) 2017-11-16 11:21:17.2531|ERROR|235|Failed to connect to AS| RequestID = s_c821fe83-856a-44af-91b8-71dfa25531bd 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 [::1]:5132 at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) --- End of inner exception stack trace --- at Microsoft.AnalysisServices.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded) at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString, String sessionId, ObjectExpansion expansionType) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout) --- End of inner exception stack trace --- 2017-11-16 11:21:17.2531|ERROR|235|Failure in reportproperties| RequestID = s_c821fe83-856a-44af-91b8-71dfa25531bd 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 [::1]:5132 at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) --- End of inner exception stack trace --- at Microsoft.AnalysisServices.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded) at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString, String sessionId, ObjectExpansion expansionType) at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout) --- End of inner exception stack trace --- at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesFactory.CreateASWrapper(String serverAddress, Int32 port, TimeSpan timeout) at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<LoadDatabaseAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PBIX.DataModelDataSourceProvider.<RetrieveEmbeddedDataSourcesAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<ShredWithModel>d__7b.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<ShredFromPreshreddedFiles>d__51.MoveNext() 2017-11-16 11:21:17.2531|INFO|235|Sending response. Response code NT SERVICE\PowerBIReportServer 400, Elapsed time 0:00:02,0194142| RequestID = s_c821fe83-856a-44af-91b8-71dfa25531bd
2. Already tested this and it didn't work.
Thanks for your help!
- Tier1SupportRegular Visitor
I'm having the same issue with both methods.
I have the october release of the report server and the powerbi desktop app. Our logs are showing the same errors.
- v-qiuyu-msftCommunity Support
Which October version did you run? I tested on the latest October version 1.1.6530.30789, not reproduce the issue. Would you please test in this version again?
Best Regards,
Qiuyun Yu- emixonRegular Visitor
I have this exact version of the PBIRS installed and get the exact same error described by the original post.
Any further insights would be appreciated.
Thanks,
Eric