CODEWITHSUNDEEP
powershellreporting-services
user3535468
user3535468

Reputation: 185

Export SSRS report from SQL 2014 using powershell

I want to automate the generation of a report from SSRS, export the report to csv and then use this data elsewhere. I have done some research and it appears that newer version of SSRS has exposed API to facilitate this. I would like to know if its possible to get the output of a SSRS report in csv using powershell or other methods.

Upvotes: 0

Views: 366

Answers (1)

Master Elodin
Master Elodin

Reputation: 41

The best way to automate report generation is to set a report subscription in SSRS which will run the report on a user-defined schedule. You can define the output format (CSV in your case), report parameters, and an output location.

The easiest way to create a report subscription is through the Reporting Services web portal.

PowerShell does have a cmdlet New-RsSubscription but you can't create a data-driven subscription this way.

Upvotes: 1

Related Questions