Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to Customize Exported File Name for All Power BI Visuals with Timestamp (workspace level)

Hi everyone,

We're trying to improve user experience with Excel exports from Power BI by customizing the exported file names. Currently, whenever we export data from a visual (via the 3-dot menu > Export data), the file is always named data.xlsx, which isn't very helpful for organization.

Our Requirement:

We want to automatically name exported Excel files using the following pattern:

CopyEditReportName_YYYY-MM-DD_HHMM.xlsx

Examples:

  • ProductList_2025-05-30_0930.xlsx

  • M3RI_2025-May-30_Export.xlsx

Constraints:

  • Needs to work at the report level or workspace level — not just per visual.

  • Manual renaming is not ideal — we want a systematic or automated approach.

  • We explored Power Automate, but it seems to apply only to single visual exports.

Tried So Far:

  1. Power Automate Flow using “Export to File for Power BI Reports” — works, but only for scheduled or single visual.

  2. DAX measure/card visual to suggest a filename — doesn’t solve the actual export name issue.

  3. Looked into REST API/Power BI Embedded — feels too heavy for this use case.

What I’m Looking For:

  • Is there any way to set or influence the exported file name for all visuals in a report or across a workspace?

  • Can Power Automate be configured to apply at the report level (not per visual)?

  • Has anyone tackled this with a Power BI Embedded, REST API, or creative workaround?

Any help, advice, or shared experiences would be greatly appreciated!

 
Need Help
Tips and Tricks
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Anonymous Power BI doesn’t natively allow customizing export file names. Use Power Automate with the REST API’s Export to File to automate exports and append timestamps dynamically (e.g., ReportName_YYYY-MM-DD_HHMM.xlsx). Apply this at the workspace level by looping through reports in the flow. You could also use Power BI Embedded for more control over export behavior.

  • BhavinVyas3003's avatar
    BhavinVyas3003
    1 year ago

    Hi Anonymous ,

     

    There is no built-in feature to auto-customize export file names from visuals (via UI) across reports or workspaces.

    Best Possible Workaround:

    • Use Power BI Embedded + Export to File REST API:
      • You can control filename using API parameters.
      • Requires embedding setup or service principal.
      • Best suited for custom portals or apps.
    • OR Create a custom Power Apps/Power Automate button inside the report:
      • Triggers export via REST API.
      • Can name the file dynamically (ReportName_YYYYMMDD_HHMM.xlsx).