Forum Discussion

dennydavis's avatar
dennydavis
Helper I
6 years ago
Solved

Modelling relationship issue

I am getting a wierd power bi desktop modelling error when connecting with multiples tables. Has there been a recent update or so. Looks so wierd an issue. Can you please help me with this    ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi dennydavis,

    Yes, current power bi does not allow you to use both two side table fields without aggregated.

    You can use left-table and right-table fields at the same time but one of them needs to be summarized, or it will display the notification message about 'can't determine the relationship between two or more fields' error.

    Regards,
    Xiaoxin Sheng

  • dennydavis's avatar
    dennydavis
    6 years ago

    I guess previously it used to allow, isn't it???

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi dennydavis,

Yes, current power bi does not allow you to use both two side table fields without aggregated.

You can use left-table and right-table fields at the same time but one of them needs to be summarized, or it will display the notification message about 'can't determine the relationship between two or more fields' error.

Regards,
Xiaoxin Sheng

dennydavis's avatar
dennydavis
Helper I
6 years ago

I guess previously it used to allow, isn't it???

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi dennydavis,

    In my memory, it seems to work in previous. (power bi will cross join them based on bridge relationship)
    I not so sure when power bi removed multiple many side fields mapping. (maybe it has been removed after 'M to M' relationship GA)

    Regards,

    Xiaoxin Sheng