How to download Graph data with same Header name

[Surekha_PM]

Hello Everyone,

I am trying to export the graph data as table but it is not showing the table header as per the calculated measure and not as per the graph header name. I could see the "Data with current layout" option, but it is not enabled. Can anyone please help me with any suggestions?

Regards,
Surekha

[Surekha_PM · Accepted solution]

Hi @Anonymous ,

Thank you for help. For now, I have made the changes in the column name in the Power BI desktop itself. So, this issue is resolved now. 

Regards,
Surekha Prasad

[Surekha_PM]

Hi @Anonymous ,

Firstly, thank you so much for your continuous reply to all my queires. Truly appreciated! Secondly, I made the changes that you suggested. Even after doing so, I don't see the option that is showing on your end.

Changes made in PowerBI Desktop:

Even after this, the report header is still same. It shows the database name in it. 

What am I missing on my end?

Regards,
Surekha

[Anonymous]

Hi @Surekha_PM,

Sorry for only seeing your reply now, can you show me what it looks like in Power BI Service?

[Anonymous]

Hi @Surekha_PM ,

Regarding your question, you need the column names of the exported data to be the same as the field names in the visualization, right?

Like this?

Please use .csv file format.

The "Use data from current layout" option automatically exports totals for table visuals or matrix visuals.

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

[Surekha_PM]

HI @Anonymous 

Thanks for your help. This works. But client might select the xlsx format while downloading the file. Is there any way to give only one option of csv to downlaod the file.

Regards,
Surekha

[Anonymous]

Hi @Surekha_PM ,

You can disable this option by contacting your administrator.

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

[Surekha_PM]

Hi @Anonymous,

Thank you for the suggestion, but unfortunately, we cannot proceed with this option. Do you know any other option to do this?

Regards,
Surekha

[Anonymous]

Hi @Surekha_PM ,

You can pin visual objects to the dashboard.

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

[Surekha_PM]

Hi @Anonymous 

I am sorry but I couldn't understand what you were trying to explain. Could you please elaborate.

Regards,
Surekha 

[Anonymous]

Hi @Surekha_PM ,

Visuals in dashboards can only export data in .csv format.

Please follow these steps:

1.First open your report and find the visual for which you want to export data.

2.Move the mouse over the visual and click the 'pin visual' button

3.Create a new dashboard in the window

4.This will create a dashboard in your workspace with the visual for which you need to export data.

5.You will find that you can only export data in .csv format.

[Surekha_PM]

Hi @Anonymous 

THank you for your quick response. I don't see the pin option, neither on the power bi server nor on desktop. Even the published report is not showing the option. Please advise.

Regards,
Surekha

[Anonymous]

Hi @Surekha_PM ,

Pin option will only appear in Power BI service.Are the following icons not displayed in your case?

Please make sure this option is not checked on your Power BI Desktop.

Make sure the header icon is turned on.