You need to add the Target field from the related entity in the solution as well. Then the mapping will work:

Attribute mappings (on N:1 relationships) not included in export?