Forum Discussion
Refresh completed with warnings
I have create tables and mixed of semantic model in this power bi. Altogether 25 tables. I have received this error message which I am not able to find it or there is no columns in my tables. how to fix this error? thanks
Error Msg
- Cannot order '<oii>LoanExceptionData (58085)</oii>'[<oii>Column (59577)</oii>] by [<oii>Column (59609)</oii>] because at least one value in [<oii>Column (59577)</oii>] has multiple distinct values in [<oii>Column (59609)</oii>]. For example, you can sort [City] by [Region] because there is only one region for each city, but you cannot sort [Region] by [City] because there are multiple cities for each region.
Hi yannaingoo , not sure why in service instead of showing the column and table name its showing the object id .
I think it's a pbi service bug, similar kind of issue reported https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Report-refresh-Table-name-not-showing-up/m-p/5142273#M1463449
To resolve this we can load the model in tmdl view and check which sort by column is causing the issue.
e.g :
I'm sorting the Sales label on sale id
in tmdl view :
in dax studio we can get the column name using the id ;
SELECT * FROM $SYSTEM.TMSCHEMA_COLUMNS WHERE [ID] = 212;Thanks
If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.
For more Power BI tips and discussions, let’s connect on LinkedIn:
https://www.linkedin.com/in/natarajan-manivasagan
Cheers!
2 Replies
I have the same problem, with two WEIRD subsets:
- First, it's referencing a Table that has since been removed altogether
- Second, the sort is failing even if the column has one single value (removed all others to test).
Hi yannaingoo , not sure why in service instead of showing the column and table name its showing the object id .
I think it's a pbi service bug, similar kind of issue reported https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Report-refresh-Table-name-not-showing-up/m-p/5142273#M1463449
To resolve this we can load the model in tmdl view and check which sort by column is causing the issue.
e.g :
I'm sorting the Sales label on sale id
in tmdl view :
in dax studio we can get the column name using the id ;
SELECT * FROM $SYSTEM.TMSCHEMA_COLUMNS WHERE [ID] = 212;Thanks
If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.
For more Power BI tips and discussions, let’s connect on LinkedIn:
https://www.linkedin.com/in/natarajan-manivasagan
Cheers!
