Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 of them need refresh weekly. How can I setup schedule refresh to achive it? 

1 ACCEPTED SOLUTION
nandukrishnavs
Super User
Super User

@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!

 


Regards,
Nandu Krishna

View solution in original post

2 REPLIES 2
nandukrishnavs
Super User
Super User

@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!

 


Regards,
Nandu Krishna

Anonymous
Not applicable

Thanks. It's very helpful

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors