?? Export (.csv/xlsx) Naming

[Anonymous]

I'm exporting some reports from a dashboard and some of the export .csv sheets are named properly and the others are named 'data'. Can anyone identify the issue?

[Icey]

Hi @Anonymous ,

I have tested on my side and it works well. 

If you are a pro user, I suggest you to create a support ticket to get further help.

Best Regards,

Icey

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

[Anonymous]

@Icey thanks for that! As I mentioned, some of the exported sheets have names, some don't (instead they are named 'data.csv'). Yes, I'm a pro user, and I'll look into creating the ticket. Cheers!

[Icey]

Hi @Anonymous ,

Is this problem solved? If Microsoft has helped you solve it, please share the solution here.

Best Regards,

Icey

[GilbertQ]

Hi there

I think it could be if your dashboard item does not have a label to it?

[Anonymous]

Can you elaborate on 'label'?

Are they the same as title? Because they all have titles. If I check in (edit details > tile details > title), they all exist.

@GilbertQ 

[GilbertQ]

Hi there

Sorry it was the Title I was referring to.

I am not sure as to why it does it differently.

Were all the extracts CSV based?

[Anonymous]

@GilbertQ the .csv is being generated from the report/visual that is in the dashboard.

Does the source still matter if they all have titles?

[GilbertQ]

I do not think it should matter, but I was trying to find out why it was different.

[Anonymous]

@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.

[GilbertQ]

Hi there

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.

[Anonymous]

@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!

[GilbertQ]

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.

[Anonymous]

Thanks!

Still trying to figure out the naming issue.

[GilbertQ]

Yeah no idea why that is happening!