Forum Discussion
Set existing column as Primary key (index)
"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.
So My guess is you want to create a unique key for each Row so that you can filter and manipulate the data. Is this what you are trying to do?
can you share an example of what you mean by implementing certain configuration for the data?
The goal is to make the model consistent with the nature of the data loaded into a particular table. If specific column is the primary key in the source data, it should be as well in the model - same logic enforced