Forum Discussion
?? Export (.csv/xlsx) Naming
GilbertQ I've also enabled the 'Display title and subtitle' option and they are all showing titles.
I can manually change the name from data.csv to actual file name, once exported, but when there are more than 50 and they need to be pulled everyday, it becomes a pain.
My question would be as to why there is a manual export that happens every day?
When all the data is contained in the Power BI reports.
And another option is to connect via Excel where you could have an Excel file which has got all the details you need with potentially 50 sheets.
This could then be opened and click refresh, save and then done.
Hi there
You can connect via Excel by going into the Power BI Service where you can see all the reports, you then get an option to connect via Excel as shown below.
This then connects via a Pivot table and you can create the exact data you need.
As far as I know in power BI Desktop you can only give your visuals a Title name, but not sure if that is reflected when exporting data.
GilbertQ can you please clarify what you mean by 'connect via excel'? Also, is there a property in Power BI Desktop that may deal with titles etc?
Also they are needed for snapshots of past (for hisotrical reference); the data source is dynamic.
Thanks for this!
Thanks!
Still trying to figure out the naming issue.
- Yeah no idea why that is happening!