PowerShell for SSRS is Here!
That’s right, you heard it here second. Today the SSRS team announced the availability of new SSRS commands in GitHub & the PowerShell Gallery.
— SQL Server BI (@SQLServerBI) November 7, 2016
To get this module just run this command in PowerShell:
Invoke-Expression (Invoke-WebRequest https://aka.ms/rstools)
After you have the module downloaded and unpacked you’ll probably want to run a command like this to find the list of SSRS commands that you will now have available at your fingertips:
Get-Command -Module ReportingServicesTools
I have been testing these commands for several weeks and so far my favorite command is Write-RsFolderContent because it will allows you to write the .RDL & .RSD files from a directory on your machine to your SSRS folder. Like the whole thing. You don’t have to throw it into a loop or anything. Try it out!
Here’s the full list of PowerShell commands for SSRS that are available today.
Give them a test and let the SSRS team know what you think!