Troubleshooting issues occurred

1. Something went wrong

Scenario:

Something went wrong

Unable to load the data model for your Power BI report.

Please try again later or contact support. If you contact support, please provide these details.

undefined:

Request ID: 1a7a0365-732e-81df-1b86-6299811a6b7f

Status code: 500

Time: Wed Jan 24 2024 11:53:00 GMT+0800 (China Standard Time)

Service version: /powerbi/libs

Solution:

方案一：

通常该方案可以解决此问题，按顺序，先重启Power BI Report Server Web服务器，重启Web服务器后再重启Power BI Report Server DB server，接着再去访问Power BI Report Server Web Portal链接看是否可以正常打开Report

方案二：

　　PBIRS版本是2023年5月份 or 9月份发布的版本，PBIRS Web/DB server上相关的 PBIRS服务和SQL服务都检查了没有问题，服务器也都重启过了，问题依然存在，查看PBIRS 日志文件，具体错误信息如下，

日志文件路径-》C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles下找以“RSPowerBI_”开头的日志文件

具体错误信息(错误信息主要内容以黑色加粗高亮显示)：2024-04-27 10:45:57.9766|ERROR|38|Failed to connect to AS| RequestID = 1b39ee17-08b4-1dc9-9169-c3386eafa103 ClientSessionID = 2f7eca53-5054-afa4-73b7-359902e5d4d4 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)

 根据以上错误信息，接合官方发布版本记录，发现该问题可能是这个版本(2023年5月or9月份)存在的一个Bug， PBIRS升级后，reports就可以打开了。

 

2. An unexpected error occurred

Scenario:

An unexpected error occurred

An unexpected error occurred. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.

We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.:

Request ID: 0d7b9a6e-df1e-76f0-6951-a90ac913c294

Time: Wed Jan 24 2024 16:07:16 GMT+0800 (China Standard Time)

Service version: /powerbi/libs

Solution:

原因可能是连接数据库的credential无效，连接数据库失败。

参考链接：https://spgeeks.devoworx.com/power-bi-we-couldnt-connect-to-the-analysis-services-server-make-sure-youve-entered-the-connection-string-correctly/