Share via

How to manage/update an SSRS data-driven subscriptions programmatically through powershell

Vijay Reddy 0 Reputation points
2023-04-28T18:38:14.73+00:00

I'm trying to create a new standard and data-driven subscription for an existing report using Powershell cmdlets, but I didn’t find a suitable cmdlet that performs a Data-Driven Subscription.

By using the powershell module "ReportingServicesTools" I was able to create a new standard subscription but not the Data-Driven because

New-RsSubscription function has only support for Timedsubscription or Snapshotupdated but not for the Data-Driven subscription

Is there any other function which supports Data-Driven Subscription?

here are the links for ref

https://github.com/Microsoft/ReportingServicesTools/

https://www.powershellgallery.com/packages/ReportingServicesTools/0.0.7.5

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.
Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-01T08:30:43.7533333+00:00

    Hi @Vijay Reddy

    I don't know much about PowerShell, I'm responsible for SSRS related issues.

    Based on my search, I didn't find an effective way to create a data-driven subscription via PowerShell.

    If you just want to create data-driven subscriptions programmatically, how about C#? I can find this link for you: https://www.codeproject.com/tips/987345/ssrs-report-subscription-using-csharp, and you can also ask for more help in C# related tags.

    Best regards,

    Aniya

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.