UPDATE ON THE PROBLEM:
Trailing spaces in ProdCenterID are ignored when imported from a CSV file but not when imported from SQL view/Stored procedure. The foreign key was created on data with trailing spaces coming from SQL data.
Note: I suspect trailing spaces come from SQL CHAR(N) data format. Data should be converted/cleaned in view/Stored procedure to avoid problems in the model.