Export Data to Excel (xslx)

[belvoir99]

There are 3 options for Export Data to Excel - Data With Current Layout, Summarized Data and Underlying Data. I can turn off Underlying Data in the PBIX Options \ Report Settings screen. However I cannot turn off Summarized Data but leave Data With Current Layout on:

The problem is Summarized Data shows the underlying column names rather than the displayed column headings in certain situations.

I'm reporting this as a Bug (Issue) rather than an Idea as it seems to me to be inconsistent with what a user might expect to see. They would expect to see the displayed column heading. I thought it might occur after I edit the column heading in the visual, but there doesn't seem to be a consistent difference between the columns I've edited and those I haven't. 

[v-yalanwu-msft]

Hi, @belvoir99 ;

Sorry, I can't reproduce your question. Can you share your original vision and the result you want to export?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[belvoir99]

Sorry, this should have been posted under Ideas (bugs) - here's the link across:

https://community.powerbi.com/t5/Issues/Export-Data-to-Excel-xslx/idi-p/2394332#M77098