How to setup difference schedule refresh for different table in same data model

[Anonymous]

I have report use multiple tables (i.e 10 tables) from same Azure DB. So, when I publish it to PoweBI service, there's one dataset. Now,  among those 10 tables, 8 of them need refresh monthly and 2 of them need refresh weekly. How can I setup schedule refresh to achive it？ 

[nandukrishnavs · Accepted solution]

@Anonymous 

By default, you cannot do that. But you can split your model into two models.

1. Model 1 (Weekly refresh) contains only 2 tables
2. Model 2 (Monthly refresh) contains 8 tables.

Publish these models into your workspace and configure the scheduled refresh.

After that, you can connect these two models using PowerBI dataset connectors. (PowerBI December 2020 update supports this feature.) If required, you can enable new relationships as well.

Reference:

Split an existing Power BI file into a model and report. https://powerbi.tips/2020/06/split-an-existing-power-bi-file-into-a-model-and-report/

DirectQuery for Power BI datasets  https://youtu.be/68YvRs49VZM?t=88

[Anonymous]

Thanks. It's very helpful