Error while opening a powerBI report on powerBI server

[sachinjagtap]

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: 504267dd-04b5-2102-faa9-9c285265bddd
Time: Mon Nov 21 2022 12:05:10 GMT+0530 (India Standard Time)
Service version: /powerbi/libs

[MajkF · Accepted solution]

I suppose that Power BI Report Server and underlying SQL Server are on the same VM / server, so networking isn't an issue here.

Did you make any changes to default name of Power BI databases "ReportServer" and "ReportServerTempDB"?

From one of my troubleshootings, I was adviced by MS support engineers to modify config file to log more details. It might help you find more details in your logs as well:

C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe.config

<system.diagnostics>

    <switches>

      <add name="DefaultTraceSwitch" value="4" />

    </switches>

  </system.diagnostics>

  <RStrace>

    <add name="FileName" value="ReportServerService_" />

    <add name="FileSizeLimitMb" value="32" />

    <add name="KeepFilesForDays" value="14" />

    <add name="Prefix" value="appdomain, tid, time" />

    <add name="TraceListeners" value="file" />

    <add name="TraceFileMode" value="unique" />

    <add name="HttpTraceFileName" value="ReportServerService_HTTP_" /> 

    <add name="HttpTraceSwitches" value="date,time, clientip,username,serverip,serverport,host,method,uristem,uriquery,protocolstatus,bytesreceived,timetaken,protocolversion,useragent,cookiereceived,cookiesent,referrer" /> 

    <add name="Components" value="all:4,http:4" /> 

  </RStrace>