Forum Discussion
Modelling relationship issue
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???
Hi Tahreem, when I am using the columns of the master and one of the child, it comes fine, but when i choose the master and use both the childs together, I get an error which says "there is no relationship between tables". But there is for sure a star relation as shown above. So why cannot i get the data from the "owner" along with "job" and "children" tables.
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???
If possible so can you share your pbix sample by hiding all confidential data. So I'll check at my end.