Forum Discussion
Data modelling in Power BI
Hi, I need to get in a few facts and dimension tables in power bi.
There are a few joins basically for my 3 dimension tables and 2 fact tables. The two fact tables are joined supposed to be joined with 1 and 3 dimension tables based on foreign keys. Now, my question is should I perform these joins in sql(backend) and get two datasets to powerbi or should I get all 5 tables (3 dimension tables and 2 fact tables) into powerbi and perform the joins in the data modelling of powerbi.
Which is the best approach considering the data size of the fact tables are huge?
Thank you
Anonymous , All 5 tables should be brought to power and you should model them here
Try to be in star schema
Refer
https://www.sqlshack.com/implementing-star-schemas-in-power-bi-desktop/
1 Reply
- amitchandak
Super User
Anonymous , All 5 tables should be brought to power and you should model them here
Try to be in star schema
Refer
https://www.sqlshack.com/implementing-star-schemas-in-power-bi-desktop/