Data parameter on Paginated report file title.

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!

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);
}