Forum Discussion

OliverO's avatar
OliverO
Helper III
7 years ago

Relationship problem

Hi I wonder if anyone can point me in the right direction?   I am building a model and am getting to the point where Power BI desktop accepts the relationships I have created, but when I start to ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

It's hard to tell from the picture, but this is generally caused by having multiple active pathways between the two tables. You have to get your relationship directions correct so that you have only a single valid pathway, or change your model slightly.

  • OliverO's avatar
    OliverO
    Helper III
    7 years ago

    Hi Greg

     

    Thanks for replying.

     

    Is the behaviour where Power BI accepts the relationships I have specified, but then refuses to allow a certain combination of fields in a visual something that you have seen before?

     

    It surprised me, but I am not the most seasoned data modeller.

     

    Many thanks

    Oliver

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Oliver,

       

      1. What are the details of the error message? You can click the "See Details" in the visual.

      2. How did you create the visual that is broken? The paths are based on the fields you chose.

      3. Can you share a dummy sample?

       

      Best Regards,
      Dale

      • OliverO's avatar
        OliverO
        Helper III
        7 years ago

        Hi Dale

         

        The error message is simply, "Can't determine relationships between fields.   Can't display the data because Power BI can't determine the relationship between two or more fields."

         

        The visual is purely a table visual.  I am having issues with the same model with the matrix visual, but thought it would be easier to demonstrate the problem with a table visual.

         

        At the moment, the data is coming in from a Filemaker database via ODBC.  I will try to make time to create a text file version, but I don't think I will be able to do that today unfortunately.

         

        Many thanks for your help though

         

        Ollie