Hi! Can you please explain why power bi is unable to autodetect the relationship btw Orders and Returns2 table with the help of orderid as primary key?
Hi ThejeswaraReddy, Please watch my latest video on data modelling as part of Power BI Zero to Hero series, Day 5 where you get an answer to this question. Orders and returns tables are both fact tables. And therefore when tried to relate them directly, it gives many-to-many cardinality which is not allowed. Kindly watch my latest videos to learn on this and how to tackle this scenario in my next video 🙏
Hi! Can you please explain why power bi is unable to autodetect the relationship btw Orders and Returns2 table with the help of orderid as primary key?
Hi ThejeswaraReddy, Please watch my latest video on data modelling as part of Power BI Zero to Hero series, Day 5 where you get an answer to this question. Orders and returns tables are both fact tables. And therefore when tried to relate them directly, it gives many-to-many cardinality which is not allowed. Kindly watch my latest videos to learn on this and how to tackle this scenario in my next video 🙏
🙂