Working with Direct Lake requires mastering many new concepts! This article covers all the essential things you should know
DISCLAIMER: The purpose of this article IS NOT to provide the answer to the question: “Which one is ‘better’ — Import or Direct Lake?”, because it’s impossible to answer, as there is no one solution to “rule them-all”… While Import (still) should be a default choice for most of the cases, there are certain scenarios in which you might choose to take the Direct Lake path. The main goal of the article is to provide details about how Direct Lake mode works behind the scenes and shed more light on various Direct Lake concepts.
If you want to learn more about how Import (and DirectQuery) compares to Direct Lake and when to choose one over the other, I strongly encourage you to read Marco Russo’s article at SQLBI.
Now, we can start:)…
I don’t know about you, but when I watch movies and see some breathtaking scenes, I’m always wondering — how did they do THIS?! What kind of tricks they pulled out of their sleeves to make it work like that?