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

     

cengizhanarslan's avatar
cengizhanarslan
Super User
4 months ago

A column in your model is configured to sort by another column, but new data has introduced rows where a single display value maps to more than one sort value — violating the one-to-one requirement. Power BI detects this conflict at refresh time and throws the warning because it can no longer determine a consistent sort order for that column. The refresh still completes, but the visual sort order for the affected column may be incorrect or unpredictable until the conflict in the data is resolved.