Adopt Rows Into Model - Invalid Reference ID Error on Insert?

I will see if I can get a clear description of why this is the case. I have a general sense of why I think it works this way, but let me verify.

The adopt rows actions are super powerful, but also fairly complex behind the scenes (from what I understand). So I would hate to misspeak on the topic.

Thanks!