topic Re: Data parameter on Paginated report file title. in Report Server

Data parameter on Paginated report file title.

GuillemCaceres — Mon, 05 Aug 2024 10:19:09 GMT

We have just implemented the paginated report solution for our users who wanted to receive an extraction every day, and they are delighted with the result.

However, they want the name of the excel file they receive not to be always the same and to to avoid being overwritten when downloading.
Is it possible to add a current date parameter to the file name?

This is very useful and something that users are requesting a lot.

Thank you very much!

Re: Data parameter on Paginated report file title.

SamWiseOwl — Mon, 05 Aug 2024 11:07:40 GMT

Hi GuillemCaceres

Sadly this isn't (to my knowledge) an available feature. There is a Power BI idea for it here:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=677c1dad-4793-ee11-a81c-6045bdba0236

The only way currently would be to embedd the Paginated Report within a Power BI report and then have a button that exports the data using a Power Automate flow.

This isn't a 1 to 1 but includes most of the steps:
https://pbi-guy.com/2023/02/03/export-paginated-reports-automatically-in-a-low-code-way-without-power-bi-premium/

Re: Data parameter on Paginated report file title.

GuillemCaceres — Mon, 05 Aug 2024 11:13:41 GMT

Hello SamWiseOwl

Thank for your reply!

It is so bad to don't have integrated an easy option like meanwhile other tool have it.

Which is the best place to make a request to Microsoft developers to think on this requirements for the next PowerBI updates?

Thanks!

Re: Data parameter on Paginated report file title.

SamWiseOwl — Mon, 05 Aug 2024 11:17:38 GMT

Comment and vote on the suggested idea. The more people vote for it the more likely they might do it:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=677c1dad-4793-ee11-a81c-6045bdba0236

Re: Data parameter on Paginated report file title.

aduguid — Mon, 05 Aug 2024 15:55:02 GMT

You could use a PowerShell script to run on Windows Task Scheduler on the server. Here's an example that saves the file. I'd set the task up under a service account.

<# Description: Weekly Performance Summary Purpose: To export reports from SQL Server Reporting Services. #> Try { $dateTimeFormat = 'yyyyMMdd'; $executeStart = Get-Date $executeStart = $executeStart.ToString($dateTimeFormat) $exportPath = 'C:\Temp\'; $ssrsPath = 'https://YourReportServer/ReportServer/Pages/ReportViewer.aspx?%2fFinance/Weekly%20Performance%20Report'; $ssrsFileName = $ssrsPath.split('/')[-1] -replace '%20', ' '; $ssrsFile = $exportPath + $ssrsFileName + $dateTimeFormat + '.pdf'; $ssrsFilePdf = $ssrsPath + '&rs:Format=EXCELOPENXML' (Invoke-WebRequest -Uri $ssrsFilePdf -OutFile $ssrsFile -UseDefaultCredentials -TimeoutSec 60); }