Forum Discussion

mohallaham's avatar
mohallaham
New Member
7 months ago

Data Modelling

Hi, I'm working on a task where the dataset consist of one fact table and four dimension tables, but there is no any common key or foreign keys between the fact table and the dimensions. Where the ...
Need Help
cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
7 months ago

If your fact table and dimension tables truly have no shared business key (no ID, code, date, name, etc.), then you cannot build a meaningful relational model in Power BI. Any relationship you create would be artificial and your measures would be unreliable.