Table relatoins using outer join?

Question

Hi all!&nbsp;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?&nbsp;Hope for help,&nbsp;. J

shill1000 · Answer

&nbsp;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.&nbsp;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.&nbsp;&nbsp;

theherkules · Answer

Thank you for the answer. I'm not using merge because this is not allowed in DirectQuery mode.&nbsp;I was talking about relationships.&nbsp;

shill1000 · Answer

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 · Answer

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 · Answer

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.&nbsp;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.

Forum Discussion

Table relatoins using outer join?

6 Replies

Related content

RTI Event Metadata Table Use Cases

PowerBI - Matrix table, hide values used only for a visual calculation

Using Aggregate Tables and Partitions

Using Kusto Explorer with Fabric tables

Use a table multiple time