I have a question with regard to best-practice modeling in PowerBI. These are the best-practices I’m using;
1 Convert relational models to star model. 2 Convert snowflake models to star model. 3 Transfer facts from dimension tables to the fact table. 4 Use bi-directional relations instead of flattening tables. 5 Flatten tables if the model is too complex(Too many dimensions/facts and relations). Make joins to reduce the number of dimensions, facts and relations. 6 Set the right data types. 7 Data cleansing.