PowerShell command to update resource in SSRS

Question

Hi there,

I have around 100 folders on an SSRS server - each containing reports.

I need to replace 2 specific reports across every folder.

The manual process to complete this is documented at the following URL:

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/update-a-resource-report-manager?view=sql-server-ver15

For convenience, here are the steps:

1. Start The web portal of a report server (SSRS Native Mode).
2. Navigate to or search for the resource you want to update.
3. Right-click the resource and select Manage from the drop-down menu.
4. Select the Properties page and then select Replace.
5. From the Open dialog box, navigate to the directory containing the file you want as the new resource.
6. Select the file that you want to use to replace the current resource. You can use an updated version of the resource file, or specify a file with a different name or file type.
7. Select Open to upload the resource file, and save your changes to the report server.

Is there a way to script this operation using PowerShell?

Many thanks,

Answer 1

Yes, with PowerShell you can interact with SSRS backend, but that requires some knowledge about PowerShell, SSRS API und take some work.
See
https://github.com/microsoft/ReportingServicesTools
https://www.mssqltips.com/sqlservertip/4738/powershell-commands-for-sql-server-reporting-services/
https://learn.microsoft.com/en-us/sql/reporting-services/tools/scripting-and-powershell-with-reporting-services?view=sql-server-ver15

Answer 2

Hi @Anvy Ramsamy ,
Not quite sure if this could be achieved by powershell, since as SSRS developer I am not very professional with PowerShell. I recommend you to change the tag to Q&A PowerShell, so engineer with more PowerShell developing experience could see and help on this issue.
Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.