Forum Discussion
Custom soft order lost on dataset refresh
Update - the defect appears to be related to the "Direct Query for Power BI datasets and Analysis Services" preview feature. If you turn off this feature, it works OK.
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
I'm using Version: 2.88.802.0 64-bit (December 2020). I was able to recreate this just now using this sample.pbix file