Forum Discussion
Resolver IPower BI Report Server September 2023: Cannot render PBIX
Resolver IHi,
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
v-alipatMicrosoft Employee
Thanks Medina !
I checked with collegues, and was informed that there were some other complains also pointing to some problems in Analysis Services. These are being investigated now.
We can't be sure if what you see is the same issue. It would greatly help if you contact Power BI Support, and open a case with them, to share more details, also they would possibly come up with a workaround for you.
https://support.fabric.microsoft.com/en-US/support
Thanks,
Alexandra
- v-alipat
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/3304565Thanks,
Alexandra