Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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 o...
Need Help
Tips and Tricks
  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    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




    Regards,
    Nandu Krishna

    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos 👍

    Proud to be a Super User!

     

nandukrishnavs's avatar
nandukrishnavs
Community Champion
5 years ago

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




Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks. It's very helpful