Dynamic file name of export

Question

HiPower BI Builder Report&nbsp; version 15.7.1813.16&nbsp;How to change the file name at the time of export I want to generate a file name with a date value Example - Report_20241012.xls&nbsp;Help me, please

anonymous · Answer

Hi&nbsp;ANDRII_SAV1971&nbsp;
&nbsp;
Do you need to automatically generate file names when exporting paginated reports? Based on my testing, I'm afraid it is not currently supported. But you can modify it manually.
&nbsp;

&nbsp;

&nbsp;
If you need to modify many files in batches, you can put them into the same folder and use PowerShell to modify them uniformly.

&nbsp;

&nbsp;
# Set the directory containing the exported Excel files
$exportDirectory = "C:\Path\To\Your\Exported\Files"

# Get today's date and format it
$currentDate = Get-Date -Format "yyyyMMdd"

# Get all Excel files in the directory
$excelFiles = Get-ChildItem -Path $exportDirectory -Filter *.xlsx

# Rename files by adding the date
foreach ($file in $excelFiles) {
    $newName = "Report_$currentDate" + "_" + $file.BaseName +$file.Extension
    Rename-Item -Path $file.FullName -NewName $newName
}

&nbsp;
If I misunderstood your needs, please feel free to correct me.
&nbsp;
Best Regards,Yulia Xu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

uzuntasgokberk · Answer

Hello&nbsp;ANDRII_SAV1971&nbsp;,You can use powerautomate. There is a node export to file for Paginated Reports. When you added&nbsp;export to file for Paginated Reports. You need to add another actions below&nbsp;export to file for Paginated Reports such as Current Time and last node needs to be addded send an email or to the related sharepoints.