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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rajendraongole1
Community Champion
Community Champion

In Export data, By default some column order is coming

Hi

 

From power bi services i am exporting underlying dataset from barchart, getting all the columns data in some default column order.

 

Can we get the exported data flow in proper order as per wish? any technique or suggestion helpful?

 

Please suggest

 

 

4 REPLIES 4
V-pazhen-msft
Community Support
Community Support

@rajendraongole1 

Unfortunately, you can not sort column when export data. The workaround is instead of apply sorting in your visual, you can do sorting in Query Editor and apply sorting for your data and brings it in your visual, then publish and update it to Service reports.

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@V-pazhen-msft - As suggested.I have tried at power query level  by reordering the columns. but once i have published the report into power bi services. still the order is coming by default.

I am not able to get the exported data for underlying data set with required column order.

 

Any suggestions?

 

Please support and let know if this feature is doable or not available.,

 

 

@V-pazhen-msft Paul Zhen,

 

I have tried reordering the columns in power query editor as per my requirement but still im not getting the order as expected it is coming in a way like calculated columns first next with some default order.

 

is that doable? can we set the reorder the column data for underlying dataset as per specific form?

 

Example: by default:

period_qq,country,customer,values1,value2,value3 value4

 

Expected result:

 

once i export the underlying data from chart

Value1,country,customer,period_qq,value3,value4,value2

 

Please suggest.

 

 

 

Hi Rajendra

Did you got any solution to the above sorting in underlying data  issue? if yes please share the solution. I am also facing the same issue.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.