Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi 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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.