Table relatoins using outer join?

[TheHerkules]

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,

. J

[wronglyappear]

select "Show items with no data" for the fields in the visualizations, and then it will shows .

[shill1000]

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]

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

I was talking about relationships.

[shill1000]

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]

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]

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.