Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have several fact and dim tables and there is a link existing in between my fact tables.
Is it better to connect the fact table through their link and 1 fact table to the dim tables ?
Or is it better to connect all Fact table to all dim tables ?
See the old school model below 🙂
Consolidated fact table is definitely not recommended as explained in the videos below from Guy In a Cube.
Hello @CapucineBenier ,
If the fact tables have the same columns and can be one table, it's better to combine all the fact tables in one table and then connect this table to the dimensions, else if this is not posssible then connect every fact table to all the dimensions.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
84 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |