Forum Discussion
Solved
Update completed with notifications.
Hi, I'm getting this message on the service power bi , but the report looks fine on the desktop. but I can't find table 165694 can you help me?
This is a "Sort By Column" conflict. You have a column set to sort by another column, but the relationship between those two columns is not one-to-one, meaning one value in the sort column maps to multiple values in the other column.
How to fix it
- Find the offending Sort By Column setting
- In Power BI Desktop, go to the Data view
- Select the table/column in question
- In the Column Tools ribbon, check "Sort by Column"
- Remove or change the sort if it's ambiguous
- Check your data for duplicates
- The column being used to sort may have inconsistent data (e.g. the same category mapped to multiple sort keys)
- Clean the data at source so the relationship is truly one-to-one
- Use DAX Studio or Tabular Editor to identify the numeric IDs (165694, 605917, 236820) and map them to real table/column names
This is a "Sort By Column" conflict. You have a column set to sort by another column, but the relationship between those two columns is not one-to-one, meaning one value in the sort column maps to multiple values in the other column.
How to fix it
- Find the offending Sort By Column setting
- In Power BI Desktop, go to the Data view
- Select the table/column in question
- In the Column Tools ribbon, check "Sort by Column"
- Remove or change the sort if it's ambiguous
- Check your data for duplicates
- The column being used to sort may have inconsistent data (e.g. the same category mapped to multiple sort keys)
- Clean the data at source so the relationship is truly one-to-one
- Use DAX Studio or Tabular Editor to identify the numeric IDs (165694, 605917, 236820) and map them to real table/column names