Forum Discussion
Left Outer Join for Multiple Tables
Hi Team, I do have 4 tables lets say A, B, C and D and my sample SQL statement looks like as shown in SQL#1 below. I was trying to mimic the same in Power BI using Advanced Editior-->Merging. Bu...
sivashankr seems like A is your fact table and other 3 are dimension table, why not you load all 4 tables in the model and set relationship from A table with other 3 tables.
Hello parry2k
Thanks for your replay.
Could you please let me know how to create the Left Outer Join in 'relationship' window as it has the cardinality 1-1, 1-M, M-1 and M-M?