When Keys are mentioned in a Power Bi context one cannot help but wonder which is the Primary or Foreign/Secondary key:
A Primary Key its like a nametag which uniquely identifies a record.
A foreign Key its a pointer to another table showing to which primary key it belong to in the other table.
Remember Power Bi is a data Modelling tool that works with structured data whose data is presented in a tabular format.
What is Tabular format
Its data presented in tables which has rows and columns.
This Tables below shows the two major Keys one in our facts table and the other in the Dimensional table.
***Facts Table :foreign Keys, or secondary keys as known form the backbone of the fact table and connects tis table to Dimension tables.
Dimension tablesA dimension table is a table that describes something — like customers, products, or dates.
The primary key in a dimension table is like a unique ID card for each row. It uniquely identifies each item in the table.
Top comments (0)