Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Solved! Go to Solution.
Hi Thomas,
There isn't a native way of doing this for the same reason there isn't a native way of doing it in Power Query:- because sorting by another column is a display/format function, not a data mashup/transformation function. I.e. there's absolutely no point doing this during ETL in either Dataflows or Power Query. They're designed to mashup/transform data into efficient structure, not to make it look pretty.
You're essentially wasting resources by doing anything in either Dataflows or Power Query that is not specifically focussed on getting the data into an aggregated and/or efficient structure. This even includes basic 'prettifying' functions such as Sort and Reorder Columns etc. These all just get scrambled once sent to the data model anyway as Power BI changes the sort/structure of the table for Vertipaq compression.
Pete
Proud to be a Datanaut!
Hi Thomas,
There isn't a native way of doing this for the same reason there isn't a native way of doing it in Power Query:- because sorting by another column is a display/format function, not a data mashup/transformation function. I.e. there's absolutely no point doing this during ETL in either Dataflows or Power Query. They're designed to mashup/transform data into efficient structure, not to make it look pretty.
You're essentially wasting resources by doing anything in either Dataflows or Power Query that is not specifically focussed on getting the data into an aggregated and/or efficient structure. This even includes basic 'prettifying' functions such as Sort and Reorder Columns etc. These all just get scrambled once sent to the data model anyway as Power BI changes the sort/structure of the table for Vertipaq compression.
Pete
Proud to be a Datanaut!