Recently when exportig data from tables using power bi, the export in the xlsx file appears (which is great), but in the wrong column order! Can there at least be an option to keep the exsitng order?
I just tried to order the column and then export Summarized data to .xlsx (Excel) file in Power BI Service, the existing order can be kept properly. Is there any difference between our testing scenarios?
Thanks for taking the time to look ito this @v-haibl-msft.
I'm running the same steps as you describe above, so this must be down to a local issue...
I have tried this on a few different reports (online) and its an issue in all of them!
If possible, you can upload you PBIX file to online file service (e.g. OneDrive) and share it. I can try to publish your PBIX file to my Service account to see if it is reproducible. Make sure you’ve removed the sensitive data before sharing.
Has this been figured out? I am have the same issue. CSV export matches the table column order from the PBI Service, but export to XLSX seems to randomly re-order the columns.
Shown is an image with all 3 column headers. The service on top, CSV (with matching header order) in the middle, XLSX on the bottom with random order headers.
The issue described by cksiz also happens to me. So the .CSV export has the columns exactly in the same order as the ones in my report, but the .XLSX export messes the order up. This seems like a bug.
Same thing here. It only happens on PBI Service and .XLSX export.
Same thing happened to me when I exported a table data to XLSX. The columns are reordered. Please suggest an option to solve this issue.
Still nothing on this! I have tried re-creating from scratch - unfortunately the same thing happens!
Our end users are also having issues with this. Our current advice is for them to export to .CSV but we'd be keen to know when the fix is available.
Please refer to https://community.powerbi.com/t5/Issues/Export-data-column-order-wrong-for-xlsx-v-csv/idi-p/118758 for the workaround.