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 both date columns are set to the date data type, and verified that there are no duplicates in the date column of the date table. Additionally, I have disabled automatic relationship creation. However, it still keeps swapping the relationship automatically.
Is this a bug in Power BI? I need the relationship to be one-to-many, and I also need to maintain a relationship between these tables for further visualization.
6 Replies
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
Do you duplicate date in the forecast table?
If so this relationship looks fine
i do have duplicates in the forecast table. My point is that i want to set a relationship where first table is date (date column) and forecast (date) as second with relationship ONE TO MANY direction single and it does not allow me and swap it to many to one relationship where table FORECAST takes first and date as second but for graphs i need this relationship to be ONE TO MANY
Hi Anonymous
I wanted to check if you had the opportunity to review the information provided by Deku and danextian . Please feel free to contact us if you have any further questions. If their response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
