Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Automatically rename a data export file (csv or excel)

Hello,

Is it possible to set the export csv or excel file name automatically for users so that they do not need to name the file when they extract data? Either the filename and/or a workbook name within the file?

  • avatorl's avatar
    avatorl
    6 years ago

    It works like I descirbed. Just make sure a visual has title. Table/matrix visuals by deafult have title disabled. Add a title.

8 Replies

  • avatorl's avatar
    avatorl
    Impactful Individual

    Do you mean 'Export data' option of a visual? In Power BI Desktop it asks for a file name and you can't predefine the name. In Power BI Service it doesn't ask for a name and uses visual's title. If the visual has no title (it's disabled or blank) than default name is 'data.csv' and you can't change it.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Sorry, yes I mean export a visual, such as a matrix or table. So you're saying it will export and name it the visual's title if there is one, correct?

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support

        Hi Anonymous ,

         

        It is a good habit to add a title to each visual, maybe you can create a dynamic title, like this.

        Measure 3 = 
        IF(
            ISFILTERED(Sales[Brand]),
            "Sales of  " &SELECTEDVALUE(Sales[Brand]),
            "AAAA"
        )

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

         

  • I want the report name in the sheet name of the exported export it is always showing as export. Any one please help