Modelling relationship issue

[dennydavis]

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 

[v-shex-msft · Accepted solution]

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

[Tahreem24]

@dennydavis ,

COuld you please share the exact error which you are facing?

[dennydavis]

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.

[v-shex-msft · Accepted solution]

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 · Accepted solution]

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

[v-shex-msft]

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

[Tahreem24]

@dennydavis ,

If possible so can you share your pbix sample by hiding all confidential data. So I'll check at my end.

[rubinboer]

hi is it possible can you give a snapshot of the error and the model.