I Also need that.
We are looking into it …
Great suggestion. It is on our radar!
It would be great to be able to set DirectQuery or In-Memory by partition. For example, newer data could be on an in-memory partition (Hot Partition) and older data on the DirectQuery Partition (Cold Partition).