Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
d_gosbell,
This worked a treat! I really do appreciate your help. For whatever reason we don't have the permissions to create subscriptions.