Forum Discussion
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/guidance/composite-model-guidance
Please give kudos or mark it as a solution once confirmed.
Thanks and Regards,
Praful
Hi Nabha-Ahmad,
In Master model If I connect Large tables using Direct Query mode, I think we can't setup incremental refresh for Large tables as it uses Direct Query in Master model.
As you said, in down stream models, we connect to Master model and pull the required tables.
and disable the enable load option for all the tables in child models.
Please let me know if my understanding is correct or not?
DirectQuery tables cannot use Incremental Refresh.
This is the same point I mentioned earlier, but I’m happy to restate it:
If a table is in DirectQuery, Incremental Refresh isn’t available.
Incremental Refresh works only when the table is in Import or Hybrid mode.
For downstream models, yes — connecting to the Master Model and disabling Enable Load on local tables is the correct approach.
Let me know if you need a quick example or diagram; happy to help.