Hello, I'm totally new on Fabric and I'm creating a dataflow.
Anyone knows why is not possible to create a merge with a referenced table? and what would be the workaround?
security table at left doesn't appear on the list for the merge.
Thank you so much for the answers.
It's because it would throw a cyclic reference error.
You would get this error if you created that merge in Advanced editor:
Could you explain what end result you wish to achieve?
Can you do the merge the other way around - merging the legacy table into the security table? That worked for me when I tried.
Or you can create a duplicate query and do the merge.
