Skip to main content

Unable to Save Reports as Office Document (Excel, Word, or PowerPoint) with SSRS 2019

Symptom​

Users are unable to save any reports as Excel, Word, or PowerPoint files with SSRS 2019. PDFs and some other formats work, but the Office-specific ones fail with the following error:

An error occurred during rendering of the report. (rrRenderingError)
An error occurred during rendering of the report.
The type initializer for 'MS.Utility.EventTrace' threw an exception.
Requested registry access is not allowed.

Cause​

The ReportingServicesService.exe process is getting an ACCESS DENIED error for the Avalon.Graphics (Microsoft) registry key.

Resolution​

To resolve the issue, you need to grant the the execution account (not the account that runs the service) Read access to the Avalon.Graphics registry key:

  1. On the computer that hosts your SQL Server instance, open Registry Editor.
  2. Navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\Avalon.Graphics.
  3. Assign the Read permission to all occurrences of the Avalon.Graphics key in the registry.