Thomas_Leillet
3 years agoRegular Visitor
Status:
Done
Issue : Duplicate primary key value detected by error because values are trimmed by Power BI Desktop
[EDIT] - I found the root cause of the issue : it seems that Power BI Desktop is trimming values and will consider (for instance) : 'AAA ' = 'AAA' -- which triggers such discrepant behavior where i...
Thomas_Leillet
3 years agoRegular Visitor
OK - well it's obvious that not everybody knows all about PBI, and specifically this trailing spaces trimming default feature (which could be troublesome in some justified situations), but at least your answer brought me the piece of info that I used to lack. Thanks !