I read couple of articles about QueryMode in Tabular. I finally noticed that hybrid modes (
DirectQuery with In-Memory and
In-Memory with DirectQuery) are NOT useful for my case. Actually they are not working the way I like.
We have huge Tabular databases and we use In-Memory for all partitions and concern is we run out of memory at some point.
My thought is, if I could use DirectQuery for old partitions and In-Memory for recent partitions (newer dates), this would help us to have fast performing reports for recent dates and keep data for recent dates in RAM and leave older data which are not accessed often to use DirectQuery.
Does my thought make sense? Is there any way we use Tabular databases this way?
Thanks for sharing your thoughts.