How can we improve Microsoft Azure Analysis Services?

Support for Hybrid mode

In old versions of SSAS you could have parts of an In-Memory cube/tabular be read directly from a source via Direct Query, this was a great feature. One of the main reason to use Direct Query is that the table you are using doesn't fit in memory and one of the main reasons to use In-Memory is that the source is too slow. Limiting users to choose mode for a whole model is bad.
Please (re-)add support for a hybrid mode where some tables are In-Memory and others are Direct Query. This is important for huge Azure SQL DW solutions where the fact tables don't fit in memory and the larger dimensions would really take good advantage of being in memory instead of having to be joined/queried along with others in the database.

71 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gösta shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Lokesh Reddy commented  ·   ·  Flag as inappropriate

        We now have this feature available in power bi named as composite models.
        Can you also add the same to AAS which is the heart of power bi for enterprise BI?

      Feedback and Knowledge Base