Forum Discussion
Issue with Power BI Relationship Automatically Changing from One-to-Many to Many-to-One
Dear all, I have tried to create a one-to-many relationship in Power BI, but it keeps changing it to many-to-one. I have made sure to mark the date table as a date table, ensured that b...
Hi Anonymous
It's always been that way. I was also confused when I first encountered it. Regardless of whether it's many-to-one or one-to-many, the relationship always flows from the "one" side to the "many" side in a single-direction relationship. The arrow in the diagram indicates the direction of the relationship flow.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand