Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
ConnieMaldonado
Responsive Resident
Responsive Resident

Change the Order of Columns when Exported using Summarized data

Is there any way to change the order of fields when you export data from a matrix using the "Summarized data" option? I have users who created automated scripts based on the exported data.

 

Several months ago, for some reason, the order of the columns changed when exported using the summarized data option. Now the users must rearrange the columns before running the scripts. I'm not sure why the order of the columns changed, as nothing changed in the report.

 

Not hopeful that there's a way to change the order, but thought I'd ask, just in case. Thanks.

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @ConnieMaldonado ,

 

As you said, you cannot make changes to the order of the exported columns of the summary data option.
For the problem that the user is having, it could be that the external filters relative to the summary data have changed before exporting.

vhenrykmstf_0-1657532751425.pngvhenrykmstf_1-1657532920025.pngvhenrykmstf_2-1657532938755.pngvhenrykmstf_3-1657532975520.png


If the problem is still not resolved, please point it out. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Hi @ConnieMaldonado ,

 

As you said, you cannot make changes to the order of the exported columns of the summary data option.
For the problem that the user is having, it could be that the external filters relative to the summary data have changed before exporting.

vhenrykmstf_0-1657532751425.pngvhenrykmstf_1-1657532920025.pngvhenrykmstf_2-1657532938755.pngvhenrykmstf_3-1657532975520.png


If the problem is still not resolved, please point it out. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.