Forum Discussion
Incremental Refresh with Sheduled Refresh
For a few days I have been testing the incremental refresh (with a Pro License) and all that topic is ok (I think so), the issue is when I have already published the report and I have noticed that the time reduction of the incremental update is only displayed when I update the data on demand and when it is scheduled it continues taking the same time as if updating all the data in the database.
My question is this:
Does incremental update only work on demand or I need some additional configuration for scheduled refresh and then take less time?
Thank you very much for your time.
Incremental refresh will work regardless of the invocation (schedule, on demand, API).
Maybe your data changes in a way that confuses the Incremental refresh queries? Remember, incremental refresh works with partitions, and relies on query folding (or crazy hacks) to define the queries for each partition.
If in doubt, use SSMS or DAX Studio to chek the size and last refresh dates for each of the partitions.
If you only see one partition then Incremental refresh isn't actually working.
4 Replies
Incremental refresh will work regardless of the invocation (schedule, on demand, API).
Maybe your data changes in a way that confuses the Incremental refresh queries? Remember, incremental refresh works with partitions, and relies on query folding (or crazy hacks) to define the queries for each partition.
If in doubt, use SSMS or DAX Studio to chek the size and last refresh dates for each of the partitions.
If you only see one partition then Incremental refresh isn't actually working.
Thanks for you help lbendlin but how can I use Dax Studio?? I'm already installed but i dont know how it works, if you can explain me or maybe share an article, url or something where I can learn how to chek the size and last refresh dates for each of the partitions.
I would really appreciate your help.
