cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.