Live Connection Export - Table Header Order Change Problem

[anilelmastasi]

Hello,

When I export data from my report using the "Data with current layout" option, the columns appear in the correct order as shown in the service (e.g., col1, col2, col3, col4).

However, when I export "Summarized Data" with a live connection, the order of the columns changes unexpectedly (e.g., col2, col1, col4, col3).

Is there a way to prevent this column order change when exporting summarized data without creating a calculated table?

Thank you.

[v-sdhruv]

Hi @anilelmastasi ,

Just wanted to check if you were able to resolve the issue by creating a support ticket or got a chance to follow the workarounds mentioned by @Shahid12523 ?

You can even raise issue here if you facing the problem- https://issues.powerbi.com/ 

Hope this helps!
Thank You

[Shahid12523]

When exporting Summarized Data with a live connection, column order follows the model metadata, not the visual order.

Workarounds:

• Rearrange fields in the visual pane.
• Create export-friendly alias measures.
• Use Analyze in Excel for controlled order.
• Build a hidden table visual just for export.

Power BI currently doesn’t guarantee order preservation for summarized exports.

[anilelmastasi]

Hello @Shahid12523 ,

Thank you for your response. Do you have an documentation link to proof that column order follows the model metadata? It would be great.

[Peter_23]

Hi @anilelmastasi  I actually is a limitation:

The granularity of data exported to Excel using the Data with current layout and Summarized data options are identical and the only difference between the options is the shape of the data in Excel. For example, in a matrix visual, the Data with current layout preserves the shape of the visual as shown in Power BI when data is exported to Excel while the Summarized data option exports the same data but as a flat table of rows and columns.

Other option is use to report builder 🙂

[anilelmastasi]

Hello @Peter_23 ,

Thank you but unfortunately column order changes. I will create a support ticket if anyone has not faced with problem.