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...
Hi Anonymous ,
I've got the same problem with "data with current layout" feature that was added recently to public preview. Column order in exported Excel files is different then in web browser. My Power BI reports connect to onprem SSAS tabular model.
I've figured out that you need to remove at least one column from the table, then add it again to table. Upload the report, and the export works just fine. Try if it works for you as well.
I think it's probably a problem with metadata in Power BI .pbix file.