Forum Discussion

jct999's avatar
jct999
Icon for Advocate II rankAdvocate II
4 years ago

DirectQuery + composite model : What can be done ?

Hello I'm going to build the following composite data model: From 2 fact tables: Fact_Table_1: Storage mode = DirectQuery, more than 10M rows Fact_Table_2: Storage mode = Import, 1K lines Crea...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

When you do the UNION you are creating a new calculated table in memory, which will not be very different from having both of your fact sources in Import Mode.  Not sure that is even possible.

 

Have you considered using Aggregations instead?