Forum Discussion

isa_bdr's avatar
isa_bdr
Regular Visitor
3 years ago
Solved

distinct table does not allow unique to unique relationship

Hi to all

 

I faced several times this issue :

 

1) create a table distinct()

2) create a relationship with another table

 

>> and power bi does not allow the one to X relationship

 

Thanks for you answsers 😉

 

Need Help
  • MahyarTF's avatar
    MahyarTF
    3 years ago

    Hi,

    Would I ask you to share sample data here?

    It could be happen when you have null value for the value that is distinct and use as a relationship between main table and distinct table 

    Appreciate your kudos and please mark it as a solution if it helps you.

     

1 Reply

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi,

    Would I ask you to share sample data here?

    It could be happen when you have null value for the value that is distinct and use as a relationship between main table and distinct table 

    Appreciate your kudos and please mark it as a solution if it helps you.