Home Exporting All SSRS Reports
Post
Cancel

Exporting All SSRS Reports

I want to backup reports within SSRS with a bulk export.

Prerequisites

  • Make sure you’re using the latest version of PowerShell
  • Install the needed modules:
1
Install-Module -Name ReportingServicesTools

PowerShell likes things to be digitally signed. To run this script without signing run the following:

1
Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass

This command will set the execution policy to “bypass” for the current PowerShell session.

Script

Find the version of SSRS you’re using. In SSRS, click => help => About SQL Server Reporting Services. Modify your URI as needed:

  • For SSRS 2010 - $sourceRsUri = 'ReportServerURL/ReportServer/ReportService2010.asmx?wsdl'

  • For SSRS 2019 - $sourceRsUri = 'ReportServerURL/ReportServer/ReportService2019.asmx?wsdl'

Set you’re export location. In my case I want to save everything to D:\SSRS_Out

Save this file as SSRS.ps1

1
2
3
4
5
6
7
8
9
#Lets get security on all folders in a single instance
#Declare SSRS URI
$sourceRsUri = "http://sqlhostname:80/ReportServer/ReportService2019.asmx?wsdl"

#Declare Proxy so we don't need to connect with every command
$proxy = New-RsWebServiceProxy -ReportServerUri $sourceRsUri

#Output ALL Catalog items to file system
Out-RsFolderContent -Proxy $proxy -RsFolder / -Destination 'D:\SSRS_Out' -Recurse

Export Data

Run our script

1
2
cd D:\SSRS_Out\
.\SSRS.ps1

Enjoy your reporting on reports of reportness.

Inspirational Source:
https://stackoverflow.com/questions/46783093/download-all-ssrs-reports

Fixing The OPNsense Package Manager Part 2

SQL Search Objects Names

Comments powered by Disqus.