Forum Discussion
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?
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
- avatorlImpactful 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.
- AnonymousNot 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-msftCommunity 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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- NikNithiyHelper I
I want the report name in the sheet name of the exported export it is always showing as export. Any one please help