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,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!