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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,785 questions
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,918 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,508 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    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 Answers by the question author, which helps users to know the answer solved the author's problem.