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.


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.

Backup-RsEncryptionKey
Get-RsCatalogItems
Get-RsDataSource
Get-RsItemReferences
Grant-AccessOnCatalogItem
Grant-AccessToRs
New-RsConfigurationSettingObject
New-RsDataSource
New-RsWebServiceProxy
Out-RsCatalogItem
Out-RsFolderContent
Register-PowerBI
Remove-RsCatalogItem
Restore-RSEncryptionKey
Revoke-AccessOnCatalogItem
Revoke-AccessToRs
Set-RsDataSet
Set-RsDataSource
Set-RsDataSourcePassword
Set-RsEmailSettingsAsBasicAuth
Set-RsEmailSettingsAsNoAuth
Set-RsEmailSettingsAsNTLMAuth
Set-RsSharedDataSource
Write-RsCatalogItem
Write-RsFolderContent

Give them a test and let the SSRS team know what you think!

Please Share This:

Share on facebook
Share on twitter
Share on linkedin

You may also like:

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow:

Subcribe to Blog Via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

What I'm Saying on Twitter

Subscribe via feedburner