Forum Discussion
Refresh completed with warnings
- 4 months ago
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!
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).