underlying data export in proper sequence

[Mhnsan1113]

Hi 

I have a sql workbench table which import and created a table in powerbi with required colums and same published on workspace and thereby Apps workspace. The major issue when user exporting the underylying data in excel, the sequence is completely disordered. see attached screeshot "block_addition_dt" , "block_release dt" shwoing in col "P" & "Q".  but "block_indicator" & "block_description" having same starting word showing almost at the end of the column "AP" & "AQ". Why this is happening. Can someone help and guide on how to sync underlying power bi as per sql table

Thanks

[v-luwang-msft · Accepted solution]

Hi @Mhnsan1113 ，

This is a known issue. I found the order of columns in exported Excel file are determined by the order when we drag fields to the table visual originally. And we got the feedback from the PG below:

"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"

For more information, you can see this same thread: Export data column order wrong for xlsx v. csv.

Best Regards

Lucien