Right Outer Join

[Anonymous]

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

[amitchandak · Accepted solution]

@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

[Anonymous · Accepted solution]

in edit query mode, reverse the steps.  

[amitchandak · Accepted solution]

@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

[d_gosbell]

So strictly speaking the data model does not have a LEFT/RIGHT join concept.

But I'm assuming that what you actually want is to show all students regardless of whether they have an attendance record or not. Typically the visuals in Power BI will hide rows that return a blank value so the "trick" is to create a measure that returns a non-blank value. So if you wanted a count of attendance you could do something like the following:

COUNTROWS( Attendance ) + 0