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
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.

    • shill1000's avatar
      shill1000
      Helper IV
      8 years ago

      I think you have just answered your own question. You can't have a relationship work where the values don't exist on one table.

       

      You could try adding a blank value record in your machineid table and see if that works, but I'm not sure it will match blank to blank.