Forum Discussion

TheHerkules's avatar
TheHerkules
Regular Visitor
8 years ago

Table relatoins using outer join?

Hi all!   When setting up relations between tables, they seem to always get resolved to inner joins (as observed in DirectQuery mode). Is it possible to make them outer joins?   Hope for help,  ...
Need Help
shill1000's avatar
shill1000
Helper IV
8 years ago

 

You can specify the relationship type by editing the relationship (1:1, 1 to many, many to 1) and filter direction (single or both), but these are not joins in the true sense.

 

But it sound more like you are merging queries? If you are, you should have been able to select the join type when creating the merge.

 

 

  • TheHerkules's avatar
    TheHerkules
    Regular Visitor
    8 years ago

    Thank you for the answer. I'm not using merge because this is not allowed in DirectQuery mode.

     

    I was talking about relationships.

     

    • shill1000's avatar
      shill1000
      Helper IV
      8 years ago

      Judging by your tables, the relationship is correct if (as I assume) your timeline table has multiple entries for each machine ID. 

       

      Without seeing the data I'd hazard a guess that you need to change the filtering to both directions?

      • TheHerkules's avatar
        TheHerkules
        Regular Visitor
        8 years ago

        The 'Zeitstrahl' table may have rows without a machineId which are filtered out when slicing for a machineId. But I'd like to see them in the resulting data.