Export table to EXCEL changes order of columns

[RSARAPEC]

When the user exports Table data as excel, the Column Headers are not Arranged properly as per the table, its exporting in the order of dataset.  But, it is working fine when we export it as CSV.

[v-haibl-msft]

@RSARAPEC

This is a known issue and currently this is by design. Export to Excel export the data from the dataset and isn't aware of visual changes that are done in PBI frontend UI like column re order.

The .xlsx field order will export in the order that the fields were originally dragged into the visualization. To change the order you need to remove the fields from the visualization and re-add them again in the correct export order.

Power BI Team are tracking on it and may change the design in the future.

Best Regards,

Herbert