Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
4 months ago
Solved

Cannot Order Table Error Message

Hi all, Refresh is completing, but with errors. The error messages is pretty generic and not very helpfule what is causing the error. What can I do to troubleshoot to get rid of the errors? T...
Need Help
  • tecumseh's avatar
    tecumseh
    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:

     

    1. If you get a handful of id's that do not make sense, translate them to the table names and column names

    2. Refresh and change names of columns - the cache is stuck.

    Thanks

    w

     

v-sgandrathi's avatar
v-sgandrathi
Community Support
4 months ago

Hi tecumseh,

 

Thank you cengizhanarslan  and tayloramy  for your answers to the query.

 

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help. 

 

Thank you.

  • tecumseh's avatar
    tecumseh
    Resolver III
    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:

     

    1. If you get a handful of id's that do not make sense, translate them to the table names and column names

    2. Refresh and change names of columns - the cache is stuck.

    Thanks

    w