Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.