Forum Discussion
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 they are active yet when i try and drag and drop field from different table into a pivot table it suggest that there are NO relationships.
Upon clicking manage relationships i can see they are all still active
As you can see im just left with a useless value. Someone please help me !!
Many thanks
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?
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
zedders1250 Well, if you don't share more info and just repeat that it doesn't work, I can't help you.
