cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

Can we get the specific order of columns once we export data from power BI services while exporting?

Hi 

 

I want to export the data from one of the visual in a specific order of the columns if i use summerize data. 

 

i have tried to reorder the same at power query editor and republished the same. but the order of the columns are not as required when i use summerize data export.

 

another option i have tried is reorder the column at DB level and i  called that table and created a visual and published the same. still the order is coming some default only.

 

any suggestion or workaround on the same?

 

 

 

4 REPLIES 4
Highlighted
Super User II
Super User II

Re: Can we get the specific order of columns once we export data from power BI services while export

Hi. I think the only work around here is to create a visualization "table" in power bi with the columns in the order you want. Then export that table. I don't think you will be able to do it from a visualization that is not a table, maybe a matrix.

Also feel free to post your idea in power bi to let the team know that this is not available: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,



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

Happy to help!

LaDataWeb Blog


Highlighted
Post Partisan
Post Partisan

Re: Can we get the specific order of columns once we export data from power BI services while export

I am using barchart visual to export summarize data. there i am getting default order.

 

I have tried to change the column order at sql server level and even at power query too.

 

still the bar chart after export getting some default export only.

 

any possibility to get in specific order ?

 

Highlighted
Community Support
Community Support

Re: Can we get the specific order of columns once we export data from power BI services while export

Hi @rajendraongole1 ,

 

I create a simple sample to try. However, it works fine. After sorting in Query Editor, do you check if it sorts correctly in data view and in the visual?

1.gif

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Partisan
Post Partisan

Re: Can we get the specific order of columns once we export data from power BI services while export

@ibarrau

 

For summarized data, bar visual as we have only two fields it is coming fine after sorting the columns but

the same way i want to export underlying dataset with all columns with specific order at backend. here it is getting failed.

the column order is coming in dafault only..

 

any suggestions.

 

Note: i have calculated columns too. 

 

 

 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors