Forum Discussion

JGohil26's avatar
JGohil26
New Member
1 month ago
Solved

How do I set a primary key in Power BI Desktop?

I'm trying to designate a column as a primary key, but I don't see the Key Column option in the Properties pane within Model View. Most examples I've found reference a "Key Column" property, but it ...
  • Kedar_Pande's avatar
    1 month ago

    JGohil26 

     

    Power BI has no primary key property like a database does. 
    Keys work through relationships instead. Put your column on the "one" side of a one-to-many relationship and it acts as the key. 

     

    If this answer helped, please click 👍 or Accept as Solution.
    -Kedar
    LinkedIn: https://www.linkedin.com/in/kedar-pande