Use Time Aggregations in Power BI Desktop (Import vs DirectQuery)

[Mitchvdd]

Is it possible to use the Aggregations function to create a table of only the year 2019 and 2020. This table then uses the storage mode 'Import', if you want to look further into the past you use the regular table that uses from 'DirectQuery' to the Datawarehouse.

Is this possible?

[amitchandak]

@Mitchvdd , Not sure I got it. But you can take advantage of composite-model.

Direct Query and Aggregation explained in

https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...