Sorting in AAS

Question

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?

Answer 1

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.