Forum Discussion
Cannot Order Table Error Message
- 4 months ago
cengizhanarslan tayloramy
Thanks for your replies. Here is what I did to resolve.Error Message Numbers
Those numbers in the error message are the id's for the table and columns respectively.
I translated those id's to names by using INFO.VIEW
INFO.VIEW.TABLES()
INFO.VIEW.COLUMNS()
Using this I was able to narrow down that the problem was my Date Table and specifically MonthName_1 (A single character for the Month Name) and the Sort Column " Sort Year Month"
I entereed the DAX for the Calculated Column in Google Gemini. Gemini recommended a few changew which I tried. No Improvement - still get an error message. 4-5 rounds of this, always an error message.
Gemini finally recommended a complete refresh and rename the the single character column to something else. The cache is stuck.
That solved it.Lessons:
If you get a handful of id's that do not make sense, translate them to the table names and column names
Refresh and change names of columns - the cache is stuck.
Thanks
w
Hi tecumseh,
This error message is telling you that a table is trying to be ordered in a non deterministic way, though it is odd that it is not telling you the table name (unless you have a table called 12587).
Are there any tables that you are defining a sort order on in your model?