Forum Discussion

Koritala's avatar
Koritala
Post Patron
7 months ago
Solved

Reusable semantic model Best Approach

Hi, I just want to know that what is the best approach to build the semantic model to avoid the duplication of creating tables.   Which is the best among below 2 appraoches. 1. create dataflows a...
  • rohit1991's avatar
    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.