Forum Discussion
cardinality changing automatically
I created a relation from CustomerKey(primary key) in Customer Table (Dimension table) to Customer Key(ForeignKey) in Sales table (fact Table) and with Cardinality "One to many" and with "Single" fil...
Hi RajD,
Can you confirm your table records are suitable for that relationship mode? If your table records changes, power bi will detect and update table relationships.
You can also turn off auto detect relationship options.
Regards,
Xiaoxin Sheng