In the world of semantic models, choosing the right storage mode is crucial. Whether you’re dealing with Direct Lake, Import, or Direct Query, each storage mode has distinct advantages and use cases.

We're diving into the different storage types that are available for your semantic models. Each of the Direct Lake, Import, and Direct Query modes has its own use case. When should you choose what? What should you consider when choosing a certain storage mode? Or even more exciting, a combination of storage modes?

We’ll delve into real-world scenarios where each storage mode shines. When should you opt for Direct Lake? How does Import mode excel in certain situations? And what about Direct Query? These questions we'll answer together.

Next to exploring the different storage modes we'll also dive into optimization strategies. Learn how to leverage aggregations effectively to boost the performance of your import models. Discover best practices for query folding in Direct Query mode. And unravel the mystery behind ‘framing’—a key concept for working in Direct Lake.

By the end of this session, you’ll be equipped with practical insights to confidently choose storage modes and optimize your semantic models.

Although anyone can benefit from this session, a basic understanding and some level of experience is assumed in the examples and demos. We won't be doing a 101 or introduction level things.