Forum Discussion

push's avatar
push
Frequent Visitor
2 years ago

Right join in Power BI

Hi team,
I have 2 Tables 
Product Table : 

 

 



Sales Table ( its on right side of right join )  : 





Where  " Sales Table " is in Right side of Right join.
After applying Right Join between product and sales table ON product_id  the Result in SQL SERVER is : 





Which is according to Right join in SQL SERVER is correct.
But after applying Right join between same Tables ( Product and Sales ) in " POWER BI "
the Result is different : 

The behaviour of Right Join in case of NULL in Power BI is Different as compare to SQL SERVER ?? 
Can anyone help me in this ...?

Anonymous PowerQueryQstn PowerBI Microsoft 




Need Help

2 Replies

  • ddpl's avatar
    ddpl
    Solution Sage
    2 years ago

    push I think you shpuld remove raw from product table where product id is null before right merge.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi push ,
    Performing a Right Outer operation in Power Bi, for each row in the right table, Power BI tries to find a matching row in the left table (i.e., the left data set). This will keep all the rows and data in the right table and will not change the null values for their mismatches. In this example, since the number of rows in the two tables is different, the right table will automatically add a row to meet the number of rows in the left table. If there are no matching rows, null is returned. this logic is differentiated from the right join of sql.
    Note that in Power Bi we use external joins, whereas in sql we change internally.
    Merge queries overview - Power Query | Microsoft Learn

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly