Centralize table refresh in Semantic Model Build

Hi Koritala ,

Explore Composite Models they are the ideal use case for you.in composite model, you can build one central model with common tables which will be used as remote model.then other 4 models can be created using this model as reference plus additional tables.in composite model, rls/ols has to be defined in the remote model only.you can also apply incremental refresh on remote model to have efficient data refresh for 15 years of data.

References:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#types-of-composite-models 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#create-composite-models-in-power-bi-desktop 

https://learn.microsoft.com/en-us/power-bi/guidance/composite-model-guidance 

Please give kudos or mark it as a solution once confirmed.

Thanks and Regards,

Praful