Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Set existing column as Primary key (index)

How do we set up existing column in a given table within the model as a primary key?   Note that we do not want/need to create an additional index column. We want to tell the model: this column is ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

"I'm not sure why you want to set an exist column as primary key"

Because I want to configure the column - and hence set the rules around data in this table - with the rules that define any PK: no null values, no duplicate values. Because otherwise I wouldn't be able to implement certain configuration involving this column - PBI won't allow it if the data is not unique and/or contains nulls.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Understand. Let's say you have a column named id with values (1,2,3) and you want a feature that can set the column as primary key. Once you use like replace value feature to replace "1" to "2", it will pop-up error message and forbid your operation.

As far as I know, there is no such feature currently and you need to submit your idea through the link above.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.