Forum Discussion
zedders1250
Jun 29, 2022Copper Contributor
data model relationships not working
Hi I have built relationships between my data tabel in power pivot. I have tried to avoid many to many relationships by connecting everything to a unique look up value table. All relationshsips say...
Riny_van_Eekelen
Jun 30, 2022Platinum Contributor
zedders1250 The message suggest that relationships MAY be needed. It doesn't say that there are no relationships.
You don't show the set-up for the pivot table. Which fields / measures from which tables did you use?
- zedders1250Jun 30, 2022Copper Contributor
Riny_van_Eekelen It doesnt matter which fields i use in the pivot table. It doesnt work unless the fields are from the same table.
Even if i use the most basic relationship so a field from custom contact received and a count of bp from lookup table i get the same message advisng that relationshis may be needed
- Riny_van_EekelenJun 30, 2022Platinum Contributor
zedders1250 Well, if you don't share more info and just repeat that it doesn't work, I can't help you.
- zedders1250Jun 30, 2022Copper ContributorI answered your question. What exactly do you need to know?