Auto rename exported paginated reports from Power Bi

[henrycqc]

Hi all

I am looking for a way to rename exported paginated reports from Power Bi

I have a Power BI report (dashboard view of data) with an embedded paginated report(table view of data) linked by company and region filters.

The issue is that every time a user exported a paginated report it retains the original name that it was saved under in the workspace.

All exports are saved in the same SharePoint folder, so It would be useful to auto rename exports with the following format as.

            data-company filter-region filter-userID.xlsx

Is there a way to this in Power Bi using either Power automate visual or DAX.

I am open to all suggestions.

Thanks

[henrycqc]

Hi,

I am using the following flow below built within Power BI using the Power Automate visual.

It runs when you click on the Powe Automate visual button.

However, the exported PDF file is corrupted and I am unable to open it.

Question: Does any know why the PDF file is corrupted?

[henrycqc · Accepted solution]

Working

Move the "create file2 into the first "Apply to each" action

[parry2k]

@henrycqc The one way I can think of using Power Automate to export with the standard file name, and after the export step, rename the file in Power Automate.