Missing Primary and Foreign Key Columns

Hi clinegirl ,

For the nuisance of relationships disappearing when you create a new semantic model, according to the official documentation, relationships, metrics and other properties are not inherited from the default semantic model when you create a new semantic model, you need to define them manually.

For more details, please see:

Improvements for creating new Direct Lake semantic models | Microsoft Power BI Blog | Microsoft Power BI

When you try to edit a relationship in the default model, the error message you’re seeing indicates that the column airline_key is missing from the table.

I have some suggestions to offer:

• Ensure that the airline_key column is not hidden in the table.
• Ensure that the airline_key column exists in the table.
• After verifying the column exists, try recreating the relationship. Go to the Model view, select the tables, and drag the airline_key from agg_monthly_airline to dim_airline.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!