Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Exporting the data from a table/matrix to CSV has the proper column order that matches the table.
However, in the service, 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.
This is coming from Project Online, however I am able to replicate using multiple data sources including SQL Server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.