cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
sachinjagtap
Regular Visitor

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 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

1 ACCEPTED SOLUTION
MajkF
Frequent Visitor

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>

View solution in original post

1 REPLY 1
MajkF
Frequent Visitor

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>

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.