Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |