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 wi...
Need Help
  • 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.

avatorl's avatar
avatorl
Impactful Individual
6 years ago

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
    6 years ago

    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
      6 years ago

      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.

       

       

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Has your problem been solved?

         

        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.

    • avatorl's avatar
      avatorl
      Impactful Individual
      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.