Sorting in AAS

Paweł Paleczny 20 Reputation points
2024-04-17T09:23:16.97+00:00

Hello All,

I'm trying to sort in Visual Studio table by date DESC (like in below screenshot) however when I deploying the model and download it in Excel the date is sorted ASC (second screen). Moreover sorting is not save when I download the model again in Visual Studio. Is there any possibility to sort by column desc in my case?

User's image

User's image

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 26,101 Reputation points
    2024-04-17T11:37:02.88+00:00

    In Visual Studio, when you're working with datasets and viewing them in tables or model designers, sorting in the interface itself (like setting a column to sort in descending or ascending order) generally only affects your current view in Visual Studio. This sorting does not modify the underlying data or its inherent order, nor does it usually persist beyond the current session. That's why when you export the data to Excel, it appears unsorted or sorted in a different manner, typically in the original order it was loaded or created.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.