Dylan Mead on 07 Mar 2023 21:49:42
The export with current layout option has solved many business requirements that previously involved complex workarounds. However, there is one scenario missing that is noted in the Microsoft documentation.
"If the Switch values to rows formatting option is set to 'On' in Power BI for a table or matrix visual, the visual format would not be preserved when data is exported to Excel."
It would be great to be able to preserve this format when exporting to Excel. This would solve one of the last highly requested export capabilities by end users.
- Comments (10)
RE: Export data with current layout switch values to rows
Would agree with other comments that this is a bug and not a feature request! “Export data as current layout” but then doesn’t export as current layout at all. Super critical for migrating business reporting and a significant block in getting users on board. Please fix this ASAP!
RE: Export data with current layout switch values to rows
A must-do for Microsoft !
RE: Export data with current layout switch values to rows
Absolut must have feature!
RE: Export data with current layout switch values to rows
I second all the comments already posted. Users are extremely disappointed that this is not avaiable.
RE: Export data with current layout switch values to rows
My team supports many partners who export data from our reports to share with their clients. Preserving formatting during the export is a key concern for them and thereby, us. Smoothing out this process would be a significant improvement in our PBI reporting.
RE: Export data with current layout switch values to rows
YES, I agree with what the previous people are saying. This would be very helpful to keep the same format instead of switching the "Values to Row" format. Maybe that could be an option that could be selected if needed but let the "Switching Values to Rows" be FALSE as the default.This would be a great help to the Power BI Community!!Thank you for listening to our concerns!
RE: Export data with current layout switch values to rows
100% agreed. I've long noticed this but haven't taken the time to submit the issue. Now seeing that the issue is already submitted, an an Idea, I have voted it up. I see this as an expectation, a bug, not an enhancement. If a user is given an option to export using 'Current Layout' but then is presented with an exported set of data with 'another layout'... well... isn't that a bug? I sure think so. I'd urge attention to getting this fixed.Related 'Issue' that has been deemed "Delivered", in my opinion, incorrectly:Export-data-with-current-layout-switch-values-to-rows/idc-p/3112736
RE: Export data with current layout switch values to rows
Please, this is very frustrating!
RE: Export data with current layout switch values to rows
I agree, this feature would be essential. I was planning to move all the reports from other report applications to Power BI, but just noticed that this feature is missing. It is going to be a big obstacle in migrating the reports.
RE: Export data with current layout switch values to rows
Yes, i am also requesting this function. Please help to have this function to ensure export excel file same format as per power BI.