PowerShell command to update resource in SSRS

Anvy Ramsamy 21 Reputation points
2020-09-16T10:24:16.76+00:00

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,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,389 questions
0 comments
Accepted answer
  1. Olaf Helper 41,001 Reputation points
    2020-09-17T05:54:36.127+00:00
    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2020-09-17T01:55:38.25+00:00

    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.

    1 person found this answer helpful.