Export data column order wrong for xlsx v. csv

I have just encountered the same issue. I would say this is a bug, because you would either expect the Excel export to follow the column order (in, say, a table visual) completely or not follow it at all. Instead, it goes with the first user-defined order and then ignores subsequent order changes, which seems arbitrary.

My use case is a large dataset with about 120 columns. In the MySQL source view, the columns are organized as we need them to be. Once I load this into PBI Desktop, the columns are sorted alphabetically. I then have to meticulously pick through the alpha list and select each column in the proper order. It's almost impossible to do this without making at least one mistake in the ordering and needing to change it. You then find your final order is not reflected in the Excel export.