Forum Discussion
Right Outer Join
Hi Experts, Is it possible to do the right outer join in the power bi Data model? SELECT * FROM attendance a right outer join student b on a.student.id=b.studentid
Anonymous
Refer merge
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
If it is dimension side , use show values with no data in Visual
If it is on fact side add +0 to formula
in edit query mode, reverse the steps.
Anonymous
Refer merge
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
If it is dimension side , use show values with no data in Visual
If it is on fact side add +0 to formula