Tabular model calculation item Ordinal property not changing

Question

I am using Visual studio 2019 and SSDT to develop a tabular model. I have created calculated groups and calculated items. I have also created an Ordinal column to sort the calculated items by a certain order When I set the Ordinal property of a calculation item, i get an error that the ordinal value must be zero or greater but its not accepting any value 0, 1, 2, 3 or anything. When I do the same in Tabular editor, it seems to work fine. Is there some bug with Visual Studio SSDT to edit the ordinal or calculated items?

Answer 1

Since you didn't provide more information, I am assuming the following :

First, ensure that Visual Studio, SSDT, and any relevant extensions or plugins are fully up-to-date. Sometimes, issues like this are addressed in minor updates or patches.

Since you've mentioned that Tabular Editor works fine, you may want to use it as a temporary workaround for managing the Ordinal property of your calculated items.

Sometimes, errors like this can be misleading. Double-check that the syntax and constraints surrounding the calculated items and the Ordinal property are correctly set up or try recreating the calculated items from scratch to see if the issue persists. There may be an underlying corruption or misconfiguration that's causing the issue.