Forum Discussion

JamesMcEwan's avatar
JamesMcEwan
Icon for Helper I rankHelper I
4 years ago
Solved

Relationship Cardinality - Many to one (*:1) issue

I have a dimtable with a distinct key column. When I try to create a relationship with my fact table, pbi desktop forces a many-to-many relationship. I have validatd via powerquery that the key colum...
Need Help
  • jgeddes's avatar
    jgeddes
    4 years ago

    I have had issues in the past with trailing spaces on my data causing this issue. 
    For example Power Query considers "cellContents" and "cellContents " as distinct where Power BI considers them a duplicate value.

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
4 years ago

I have had issues in the past with trailing spaces on my data causing this issue. 
For example Power Query considers "cellContents" and "cellContents " as distinct where Power BI considers them a duplicate value.