Hi everyone,
In Power Query, I removed duplicates from a table to get a unique list of storage areas. However, I still ended up with two nearly identical entries — the only difference is that one of them has a trailing space character at the end.
When I try to create a 1:n relationship between this table and another one in the Model view, Power BI reports that there are duplicate entries in the table (even though I removed duplicates). It seems that Power BI ignores the trailing space character when checking for duplicates, which prevents the relationship from being created.
Has anyone else experienced this behavior?
Thanks!
CDi
Hongju_Jung
on:
Translation Issue in the Korean Version
on:
Issue with new card visual - reference labels spac...