Forum Discussion
Power BI Report Server September 2023: Cannot render PBIX
Hi,
Below is the info from the RSPowerBI log file. Thank you!
2023-10-06 08:59:57.9422|INFO|112|Sending response. Response code domain\username 500, Elapsed time 0:00:02.3326553| RequestID = 521e3e2f-e940-6a0d-1bc1-341cdf8bcf14 ClientSessionID = d023b467-0c4d-767b-b72e-0bf830007451
2023-10-06 09:00:06.4055|INFO|88|Received request GET /api/explore/reports/2772871c-4c20-4100-ba8e-fcaf3c9ab1e4/modelsAndExploration| RequestID = aadd6b12-5f9c-de5d-3465-682379760425 ClientSessionID = d023b467-0c4d-767b-b72e-0bf830007451
2023-10-06 09:00:08.7919|ERROR|112|Failed to connect to AS| RequestID = aadd6b12-5f9c-de5d-3465-682379760425 ClientSessionID = d023b467-0c4d-767b-b72e-0bf830007451 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
at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(IConnectivityOwner owner, ConnectionInfo connectionInfo)
--- End of inner exception stack trace ---
at Microsoft.AnalysisServices.XmlaClient.OpenConnectionAndCheckIfSessionTokenNeeded(ConnectionInfo connectionInfo)
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 ---
2023-10-06 09:00:08.7919|INFO|32|Sending response. Response code domain\username 500, Elapsed time 0:00:02.3870728| RequestID = aadd6b12-5f9c-de5d-3465-682379760425 ClientSessionID = d023b467-0c4d-767b-b72e-0bf830007451
2023-10-06 09:00:25.3749|INFO|107|Received request GET /api/explore/reports/2772871c-4c20-4100-ba8e-fcaf3c9ab1e4/modelsAndExploration| RequestID = db6d34d8-e2f6-012f-634e-e6ad4656d898 ClientSessionID = d023b467-0c4d-767b-b72e-0bf830007451
2023-10-06 09:00:27.7424|ERROR|109|Failed to connect to AS| RequestID = db6d34d8-e2f6-012f-634e-e6ad4656d898 ClientSessionID = d023b467-0c4d-767b-b72e-0bf830007451 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
at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(IConnectivityOwner owner, ConnectionInfo connectionInfo)
--- End of inner exception stack trace ---
at Microsoft.AnalysisServices.XmlaClient.OpenConnectionAndCheckIfSessionTokenNeeded(ConnectionInfo connectionInfo)
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 ---
2023-10-06 09:00:27.7424|INFO|98|Sending response. Response code domain\username 500, Elapsed time 0:00:02.353554| RequestID = db6d34d8-e2f6-012f-634e-e6ad4656d898 ClientSessionID = d023b467-0c4d-767b-b72e-0bf830007451
2023-10-06 09:00:27.8966|INFO|107|Received request GET /libs/styles/InfoNav-Sprites.png| RequestID = s_46c97384-44a1-4473-890a-c06f8d544336
Medina hi again,
Until a permanent fix in RS is provided, you can try out a workaround suggested in this thread to unblock yourself:
https://community.fabric.microsoft.com/t5/Report-Server/Microsoft-PowerBI-ReportServer-AsServer-AsConnectionException/m-p/3304565
Thanks,
Alexandra