Forum Discussion
Reusable semantic model Best Approach
- 7 months ago
Hii Koritala
For avoiding duplicate table creation and reducing backend query load, using Dataflows as the source for multiple semantic models is the best approach. Dataflows extract and refresh data once, store it centrally, and then all semantic models reuse the same prepared tables, so the source system is not queried repeatedly. Creating a master semantic model and using it in child models helps with reuse, but it does not fully prevent multiple query executions during refresh and creates tight coupling. Best practice is Dataflows for shared data + separate semantic models for modelling and measures.
Hii Koritala
For avoiding duplicate table creation and reducing backend query load, using Dataflows as the source for multiple semantic models is the best approach. Dataflows extract and refresh data once, store it centrally, and then all semantic models reuse the same prepared tables, so the source system is not queried repeatedly. Creating a master semantic model and using it in child models helps with reuse, but it does not fully prevent multiple query executions during refresh and creates tight coupling. Best practice is Dataflows for shared data + separate semantic models for modelling and measures.