Hey! Great question.
Thanks @ScottR for jumping in here. To answer your question, yes this is a known bug where the primary key cannot be dynamic 
.
@Jorge_Cimentada Tess has a great post on this, I recommend checking out. One part I'd like to highlight is dynamic columns. You may still run into an issue with primary keys so another option is to use two tables. 