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...
As we all know that DAX does not recoginze space and capitalization . When your values are "AAA" and "AAA ", you always get "AAA" in Desktop view .
As for the "The issue did not occur when modeling in Direct Query mode, but appeared when attempting to switch ot either Import or Dual mode." you mentioned , my understanding is when you import your data from data source , Power Query will perform a transformation on the data , it is normally in Power Query Editor , but back to Desktop view , it will say "duplicate Key with value " INC." .
Best Regards,
Community Support Team _ Ailsa Tao