From the course: Introduction to Microsoft Fabric by Microsoft Press
Join today to access over 24,700 courses taught by industry experts.
Understand Direct Lake - Microsoft Fabric Tutorial
From the course: Introduction to Microsoft Fabric by Microsoft Press
Understand Direct Lake
- To understand what Direct Lake is, let's start with some of the basic concepts in semantic models. You could say that the main design goal for a semantic model is to enable interactive visual reports. This means two things. The model needs to be able to calculate aggregations on the underlying data, and it needs to do so super fast. The way this is a complex is first to have a storage mechanism that is tailored to this purpose of fast aggregations. This is done through a storage engine that stores tables of data and models relationships between these tables. Back in the days of Power Pivot, when it all started, Microsoft developed a column-based storage engine that is optimized for this purpose. Storing data in columns allows for compression of the data at a tremendous rate, which in many cases makes it possible to keep the complete model in memory. And this speeds up all data operations even further. The second component is a compute engine for calculating sophisticated…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.