YouTube Channel!

Enable Verbose Logging – SSRS & PBIRS

Enable Verbose Logging

Enable Verbose Logging: Enabling verbose logging for SQL Server Reporting Services (SSRS) & Power BI Report Server (PBIRS), you need to make some changes in the configuration files which will mentioned below and registry keys if possible. Depending totally on what component you want to enable the verbose logging feature, you can follow these below mentioned steps as listed.

Table Of Contents
  1. Verbose For SSRS?
  2. Verbose For PBIRS?
  3. SQL Bi Links:

Verbose For SSRS?

To find the “ReportingServicesService.exe.config” please find the below file path, if you did not install the Reporting services on default location then just directly search for the file directly in your computer. In my case as you can see that I have my SSRS installed on default location. The version which I am currently using for SSRS is 2019, so I will follow the below path and search for the location.

RS VersionFile Location
2012C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin
2014C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\bin
2016C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\bin
2017C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
2019C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
ReportingServicesService.exe.config default file locations are listed above.
image 13

Steps For SSRS

  1. Backup the ReportingServicesService.exe.config file.
  2. Open the ReportingServicesService.exe.config file for editing.
  1. Change this below Tag:

Change this:

<system.diagnostics>
<switches>
                <add name=”DefaultTraceSwitch” value="3" />
</switches>
</system.diagnostics>

To this:

<system.diagnostics>
<switches>
                <add name=”DefaultTraceSwitch” value="4" />
</switches>
</system.diagnostics>
  1. Also Change this below Tag as well:

Change this:

<add name=”Components” value=”all:3” />

To this:

<add name=”Components” value=”all:4” />

5. Now the SSRS verbose is enabled and please don’t forget to re-start the SSRS server to make this changes effect.

Verbose For PBIRS?

The good thing about PBIRS is that we don’t have multiple versions as SSRS. I mean to tell that PBIRS will have the same file location no matter what version of PBIRS you use. The SSRS differs because the prior to SQL 2016 the SSRS & SQL Server were both integrated in the setup file itself.

RS VersionFile Location
PBIRSC:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin
ReportingServicesService.exe.config default file locations:
image 11

Steps For PBIRS:

  1. Backup the ReportingServicesService.exe.config file.
  2. Open the ReportingServicesService.exe.config file for editing.
  1. Change this below Tag:

Change this:

<system.diagnostics>
<switches>
                <add name=”DefaultTraceSwitch” value="3" />
</switches>
</system.diagnostics>

To this:

<system.diagnostics>
<switches>
                <add name=”DefaultTraceSwitch” value="4" />
</switches>
</system.diagnostics>
  1. Also Change this below Tag as well:

Change this:

<add name=”Components” value=”all:3” />

To this:

<add name=”Components” value=”all:4” />

5. Now the PBIRS verbose is enabled and please don’t forget to re-start the PBIRS server to make this changes effect.

Enable Verbose Logging Info

Enable Verbose Logging: The below images show how the config files looks once you make these above changes. For more details, please check this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-service-trace-log?view=sql-server-ver16

image 12
Note: Make sure to take backup of the config file before making any changes in the config files.

SQL Bi Links:

  1. Kerberos Issue: NT AuthorityAnonymous Login Failed -Resolve (kingfishertechtips.in)
  2. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  3. RS.exe Utility: Migrate RDL Reports To Another SSRS/PBIRS (kingfishertechtips.in)
  4. Direct Query Mode ON In Tabular Model Issue – Visual Studio (kingfishertechtips.in)
  5. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  6. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  7. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  8. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  9. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  10. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  11. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  12. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  13. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  14. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  15. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  16. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  17. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  18. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 108

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *