Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

harleyD

Export a table to Excel in the right column order...

Submitted by on ‎12-15-2016 08:53 AM

 Recently when exportig data from tables using power bi, the export in the xlsx file appears (which is great), but in the wrong column order! Can there at least be an option to keep the exsitng order?

Status: New
See more ideas labeled with:
11 Comments (11 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎12-20-2016 02:13 AM

@harleyD

 

I just tried to order the column and then export Summarized data to .xlsx  (Excel) file in Power BI Service, the existing order can be kept properly. Is there any difference between our testing scenarios?

 

Export a table to Excel in the right column order_5.jpgExport a table to Excel in the right column order_3.jpgExport a table to Excel in the right column order_4.jpg

 

Best Regards,

Herbert

harleyD
Frequent Visitor
‎12-20-2016 02:37 AM

Hi, 

 

Thanks for taking the time to look ito this @v-haibl-msft.

I'm running the same steps as you describe above, so this must be down to a local issue...

I have tried this on a few different reports (online) and its an issue in all of them!

 

Oh well!

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎12-21-2016 09:45 PM

@harleyD

 

If possible, you can upload you PBIX file to online file service (e.g. OneDrive) and share it. I can try to publish your PBIX file to my Service account to see if it is reproducible. Make sure you’ve removed the sensitive data before sharing.

 

Best Regards,

Herbert

Anonymous
Not applicable
‎01-20-2017 01:50 PM

Has this been figured out? I am have the same issue. CSV export matches the table column order from the PBI Service, but 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.

 

2.png

Guust
Regular Visitor
‎01-31-2017 08:32 AM

The issue described by cksiz also happens to me. So the .CSV export has the columns exactly in the same order as the ones in my report, but the .XLSX export messes the order up. This seems like a bug.

carvalhoelder
Advocate II
Advocate II
‎01-31-2017 10:35 AM

Same thing here. It only happens on PBI Service and .XLSX export.

v-sadadi
Microsoft Employee
Microsoft Employee
‎02-14-2017 01:25 AM

Same thing happened to me when I exported a table data to XLSX. The columns are reordered. Please suggest an option to solve this issue.

harleyD
Frequent Visitor
‎02-22-2017 04:25 AM

Still nothing on this! I have tried re-creating from scratch - unfortunately the same thing happens!

ThwaiVA
Regular Visitor
‎03-27-2017 03:13 PM

Our end users are also having issues with this.  Our current advice is for them to export to .CSV but we'd be keen to know when the fix is available.

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎03-29-2017 12:59 AM

Please refer to https://community.powerbi.com/t5/Issues/Export-data-column-order-wrong-for-xlsx-v-csv/idi-p/118758 for the workaround.

 

Best Regards,
Herbert

Idea Statuses