Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
3 years ago

Relationships in Power BI

Hi,

 

I would like ask why I can't connect tables one-to-one relationship? I am getting message: 

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Analitika Somewhere you have a duplicate value in those columns or you have unmatched rows. The first issue might be caused because of the case insensitivity of DAX, something like AQ701 is the same as aQ701 is the same as aq701 is the same as Aq701, at least as far as Power BI is concerned. But, it really looks like the latter where you have a bunch of rows in your 2nd table that don't match anything in your first table.

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      3 years ago

      I tried to make table to be distinct but still seems it has  duplicates. Seems it is a reason that I can't make one-to-one relationship.