Forum Discussion
how to merge a referenced table in a dataflow
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 a...
frithjof_v
Community Champion
Community ChampionIt'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.