Summary
In this chapter, we looked at large data volumes. We reviewed the limitations of desktop licenses as well as the capacities available to handle large loads. Technically, we can use all the available memory on the capacity, which is 400 GB on the largest Fabric or Premium capacity. We also provided suggestions for addressing CPU and memory issues with capacities and AAS.
After that, we looked at improving DirectQuery performance with composite models, a feature that lets you combine Import mode and DirectQuery data sources. The Dual model demonstrated examples that included monitoring in DAX Studio. Aggregations were reviewed to improve composite models, particularly when dealing with large fact tables where queries are frequently aggregated by dimensional attributes. DirectQuery was then used for reporting involving more rows, which can go to DirectQuery for results and result in longer query times. These situations are not frequently encountered by users, and it is understood...
