The composite model enables you to have huge tables as a DirectQuery source, and some other smaller tables as in import mode. When we talk about huge tables, performance is always a challenge. In this session, we talk in-depth about how aggregations can be helpful for speeding up performance. You can see how the terabytes of data can be analyzed and visualized in less than a second. Learn many tips and tricks and internals about aggregations in Power BI and usage of that in a composite model. The session is full of live demos.

For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.