Forum Discussion
Custom soft order lost on dataset refresh
I have an existing .PBIX dataset file. In a table (Financial Summary Dimension) I have overridden the sort order for the Full Name column (rather than sorting by Full Name, it's configured to sort by my 'Sort Order' column). This has worked fine for well over a year.
Last week I installed the December 2020 edition of Power BI Desktop (x64 version). Now, when I refresh the dataset in PBI Desktop, any custom sort order settings are lost for all fields so configured (there are many of these).
I un-installed the December 2020 edition and installed the November 2020 edition. Now, when I refresh, the custom sort order settings are preserved.
Is anyone else seeing this?
11 Replies
Anonymous I think it is a known issue, by chance you using the composite model.
Anonymous Not I'm aware of, do you have a most recent update of Dec 2020. Here is the one.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
HI Anonymous,
Can you please share some dummy data or a pbix file to test? It is hard to reproduce the issue on my side without any sample data.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Here's the detailed steps to reproduce. With Power BI Desktop December 2020 release:
- Create a new blank .PBIX
- Import the sample.csv data listed below.
- In the Fields view, select the Full Name column
- On the Column Tools ribbon, select Sort by column... Sort Order.
- Refresh the data set.
- On the Column Tools ribbon, note that the Sort by column has reverted to Full Name.
- This is a problem.
Now uninstall Power BI Desktop and install the November 2020 release instead. Repeat the 6 steps above. At step 6 you will note that the Sort by column is still Sort Order. This is the correct behaviour.sample.csv:Full Name,Sort Order
Consulting Revenue,100
Baseline Revenue Fees,101
Consulting Cost of Sales: Direct COS,102
Consulting Cost of Sales: Direct COS %,103
Client GP,104
Client GP %,105
Consulting Cost of Sales: ConsultingOps Costs,106
Consulting Cost of Sales: ConsultingOps Costs %,107
Consulting Cost of Sales,108
Consulting Cost of Sales %,109
Consulting Gross Profit,110
Consulting Gross Profit %,111Hi Anonymous,
What type and version number of power bi desktop do you test? (e.g. store version/download version)
I test on download version [2.88.802.0 64-bit (December 2020)] and can't reproduce this scenario. The refresh dataset operations did not reset the sorting orders fields.
Snapshot
Please update your desktop client to the last version and try again to confirm if this issue has been fixed on the latest versions.
Regards,
Xiaoxin Sheng
