Forum Discussion

vazperen's avatar
vazperen
Frequent Visitor
8 years ago
Solved

Duplicate value not allowed, many to many

      Hello, Newby with databases and PowerBI.  I was creating a table with Horse racing results and everything went well until one horse finally showed up again under the results table.  I have t...
  • vanessafvg's avatar
    8 years ago

    vazperen you will need to create a distinct list of horses, you cannot do many to many directly, there has to be a unique lookup table in the middle, get a distinct list of the horse column and place it between the tables you have remapping the relationship.

     

    do you need a many to many relatioship?   where are you filtering the data from in your visuals, you shouln'dt use the  both option unless you know how it works