Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Many to Many Raltionship issue

Hi All,

 

I have a doubt in the below blog:

 

https://powerpivotpro.com/2018/01/dynamic-attributes-power-bi-report/

 

If i dont have unique Invoice (just for assumption) then i will be getting many to many relationship issue.

How to overcome such scenarios when we dont have primary key column in the table.

 

Thanks in advance.

 

Regards,

Prakash 

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can add a Index column as the invoice column to connect other table.

     

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We can add a Index column as the invoice column to connect other table.

     

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.