Forum Discussion
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 ...
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 ShengI guess previously it used to allow, isn't it???
I guess previously it used to allow, isn't it???
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