ThalesFerraz's avatar
ThalesFerraz
Icon for Kudo Commander rankKudo Commander
10 years ago
Status:
Needs Votes

Create a different schedule refresh for each table (with a single dataset)

Hello there, How do i create a different schedule refresh for each table (with a single dataset)? Please, see the image below: http://community.powerbi.com/t5/Integrations-with-Files-and/Create-a-different-schedule-refresh-for-each-table-with-a-single/m-p/55889/highlight/false#M4660 The image above shows a group of relationship tables. In this image i put numbers from 1 to 6 . Specifically I need to do is: Number: Action 1: Refresh 1 time per week 2: Refresh 8 times per day 3: Refresh 1 time per day 4: Refresh 1 time per month 5: Never refresh (this table is heavy and only needs to be updated on demand.) 6: Refresh 1 time per day Sincerely, Thales Ferraz

9 Comments

  • Another option to simplify this is to create "Refresh Groups". First you define to which "refresh groups" each table belong to, and then the refresh period of which "refresh group".
  • I like this idea, as it's what I was hoping to be able to do too, though I see this was first requested in 2016, so I guess it means it not high on the list of priorities!
  • Please!! Super helpful for reconciliation reports that show current and cleared items!!

  • This is actually very needed in different scenarios. Not all of the tables have the same frequency of loading data.

  • I agree this is very needed. I know its old, but I think its still very relevant. For example, we have a report that has a very large data load but only once per week. But we need another table updated daily. This is a very small table. In order to preserve resources on the server, it would be ideal if we could refresh the large portion of the model only once per week, and the small table daily.

  • This is very needed as different table will serve different purposes and have different data refresh schedule

Recent ideas