Automating export/download of Linked Report

[mewisenb]

Is it possible to automate downloading/exporting a Linked Report as a regular user?  I've been futzing around with the SSRS powershell module, but have not made much headway. 

[d_gosbell · Accepted solution]

If the original report uses data sources with stored credentials you should be able to setup a report subscription to output the report to a file on a scheduled basis. But if the report uses windows authentication this is not possible.

If you wanted to use powershell you could use url access to get an export of the report see  https://docs.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-se... 

So you could use something like the following:

Invoke-WebRequest -Uri "http://localhost/reportserver?/Demo%20Reports/Products%20by%20Colour&ProductColor=Black&rs:Format=EXCELOPENXML" -OutFile "c:\temp\report.xlsx" -UseDefaultCredentials

I ran this on my local dev server and it exports the "Products by Colour" report with a parameter value of "Black" and outputs the results to an excel file.

[mewisenb]

d_gosbell,

This worked a treat!  I really do appreciate your help.  For whatever reason we don't have the permissions to create subscriptions.