Power BI
Needs VotesCreate a different schedule refresh for each table (with a single dataset)
on 05 Aug 2016 18:58:24
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
- Comments (7)
RE: Create a different schedule refresh for each table (with a single dataset)
This is very needed as different table will serve different purposes and have different data refresh schedule
RE: Create a different schedule refresh for each table (with a single dataset)
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.
RE: Create a different schedule refresh for each table (with a single dataset)
This is actually very needed in different scenarios. Not all of the tables have the same frequency of loading data.
RE: Create a different schedule refresh for each table (with a single dataset)
Please!! Super helpful for reconciliation reports that show current and cleared items!!
RE: Create a different schedule refresh for each table (with a single dataset)
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!
RE: Create a different schedule refresh for each table (with a single dataset)
Great idea
RE: Create a different schedule refresh for each table (with a single dataset)
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".