Forum Discussion
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, ...
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.
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.