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
on:
Open old report, PowerBi hangs
mattlee
on:
Error：Visuals display blank when export report to ...
on:
New Button Slicer: Issue with the Grid type of Arr...
on:
BUG: report connected to deleted semantic model ca...