Export SSRS 2014 report using powershell

Question

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.

Answer 1

Hi @MrFlinstone ,

To export SSRS to csv, you may refer this two links for help.

https://www.mssqltips.com/sqlservertip/4738/powershell-commands-for-sql-server-reporting-services/

https://stackoverflow.com/questions/28740951/ssrs-and-powershell-get-report-as-excel

Here is also a blog about code for rendering SQL Reporting Services Report to desired file types (PDF, XLS etc.).

In addition, we could also use SSRS subscription to save the reports to local shared folders with rendered format.

file-share-delivery-in-reporting-services

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October