Primary & Secondary Keys In Power Bi.

Source: Dev.to

Understanding Primary and Foreign Keys in Power BI

When keys are mentioned in a Power BI context, it’s helpful to differentiate between primary keys and foreign (secondary) keys:

• Primary Key – a unique identifier for a record, similar to a nametag.
• Foreign Key – a pointer to another table that indicates which primary key it relates to.

Power BI is a data‑modeling tool that works with structured data presented in a tabular format (rows and columns).

What Is Tabular Format?

Tabular data is organized into tables with rows (records) and columns (fields). This structure allows Power BI to model relationships between tables efficiently.

Fact Tables

Fact tables contain foreign keys (also called secondary keys). These keys form the backbone of the fact table and connect it to dimension tables.

Dimension Tables

A dimension table describes entities such as customers, products, or dates. The primary key in a dimension table acts like a unique ID card for each row, uniquely identifying each item.

---

Hope you find this helpful.