Forum Discussion
Automatic refreshes never pull in changes (UPDATED)
We incrementally refresh our semantic model every 30 minutes using the services's scheduler. As far as I know, scheduled refreshes perform a refresh type Automatic. This works fine.
That makes little sense as the smallest partition is a daily partition. You will want to look into keeping the "today" partition in direct query mode.
Note: For your API refreshes you should replace "automatic" with "full" to force the refresh.
I've delayed following up because I wanted to monitor things for a few days. And I have never, not once, seen even the dirtiest of partitions be marked as anything other than "Ready". I really can't imagine a scenario where Automatic would actually do anything.
This is puzzling, because I was told her on the forum some ago that the service's scheduled refreshes performance an Automatic. That can't be true, seemingly, or our scheduled refreshes would never actually refresh a table -- but they do.
I have changed everything to Full as you suggest, and which is clearly the correct answer, and our API refreshes are working now. It's odd though: it feels like the scheduled refreshes aren't doing Full either, simply because a scheduled refresh can update our entire 30+ table model in not too much more total time than one of our programmatic API refreshes can do a more narrowly-targeted ~5 tables.
Frustrating behavor overall, but at least our targeted refreshes are working now.