Forum Discussion
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 ...
If there is no common key between fact and dimension tables, you cannot build a clean data model directly, so you must create one. The correct approach is to derive a surrogate or composite key using common business fields like date, region, product, or category after cleaning and standardising the data in Power Query. If the relationship is many-to-many, a bridge table can be used. Without establishing a relationship, dimension-based measures will not work properly in the report.