Forum Discussion
Export "data with current layout" gives wrong column order
I have used in the past ‘Summarized data’, which is great to export data. Now I am using ‘Data with current layout’ And it’s very annoying that it mixes the column order wherea...
So, for example the PBIX is showing:
If I export using "Summarized data", this problem does not occur, if I use "Data with current layout" I do experience the issue, very annoying!
I see a different order:
So, if the pbix has col1, col2, col3 displayed, the export in excel will have col3, col1, col2.
ps: not sure if it makes a difference but the .pbix consumes from a SSAS cube.