OK, I needed keys in both tables. Dataflow was still failing but it could see the lookup column. I wrote a flow in Power Automate to handle the import instead.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.