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...
Having this same problem (in 2025). The order of columns as they appear in my Matrix is not the order when exported.
What I've found is that PBI seems to export in the order that the columns were added. So if I add Column A, then Column C, then Column B and rearrange it to Column A > Column B > Column C the exported order will be A, C, B (as that's how I added them). If I add them initially as Colum A, then Column B, then Column C they will export as expected. This means that, for my Matrix with 11 columns that I can't mistakingly place one in the wrong order (or otherwise change my mind) and simply re-arrange it. I have to order them correctly the first time through or re-do it entirely.