Forum Discussion
Relationships deleted on refresh
Hi guys, I'm having a problem where all of my relationships to a particular table are being deleted each time I refresh my data (just these relationships - the rest are still fine). I have turned...
greggyb
Resident Rockstar
Resident RockstarCan you recreate the relationships between those tables after your data refresh has completed?
Does your refresh invalidate the relationship by loading duplicate keys into both tables? Power Pivot only natively supports 1:1 and 1:N relationships, but not N:N.
I can re-create the relationships. And the dimTable always has unique values.. What else could it be?