Forum Discussion

sachinjagtap's avatar
sachinjagtap
Regular Visitor
3 years ago
Solved

Error while opening a powerBI report on powerBI server

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 conn...
PowerBI Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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>
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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>