DDrona4U
Sign inCreate account
My learningMicrosoft Fabric Interview QuestionsLesson 14
Import vs DirectQuery vs Direct Lake

Lesson 14

Import vs DirectQuery vs Direct Lake

Import = fastest performance, but data is copied into Power BI DirectQuery = always queries source live, but can be slower Direct Lake = reads directly from OneLake, combining speed + freshness without copying data

Get the full lesson

Sign in to unlock everything beyond the preview — it's free.

  • Take timestamped notes as you watch
  • Read the full transcript and download resources
  • Join the discussion and track your progress
Sign inCreate free account

Curriculum

20 lessons · 38m

0/20 lessons done38m left
  1. 0101:59

    What is Microsoft Fabric, and what business or technical problems does it solve?

    01:59

  2. 0201:54

    What are the Core Workloads in Microsoft Fabric

    01:54

  3. 0301:47

    What is OneLake and Why is it Central to Microsoft Fabric

    01:47

  4. 0401:58

    How is OneLake Different from Azure Data Lake Storage

    01:58

  5. 0501:51

    Explain Microsoft Fabric's Licensing and Capacity Model

    01:51

  6. 0601:54

    What Data Format Does Microsoft Fabric Use, and Why Does It Matter

    01:54

  7. 0702:01

    What is the Difference Between a Lakehouse and a Warehouse in Microsoft Fabric?

    02:01

  8. 0801:53

    When Would You Choose a Lakehouse Over a Warehouse in Microsoft Fabric

    01:53

  9. 0901:56

    What is the SQL Analytics Endpoint of a Lakehouse in Microsoft Fabric

    01:56

  10. 1001:49

    What Are Shortcuts in OneLake

    01:49

  11. 1102:05

    What is Mirroring in Microsoft Fabric and Why is it Useful

    02:05

  12. 1201:50

    How does Fabric Spark differ from Azure Databricks

    01:50

  13. 1301:46

    What is Direct Lake mode in Power BI

    01:46

  14. 01:50

    Import vs DirectQuery vs Direct Lake

    01:50

  15. 1501:51

    What is V-Order and how does it relate to Direct Lake performance

    01:51

  16. 1601:54

    What is a Semantic Model in Microsoft Fabric

    01:54

  17. 1701:53

    What happens when Direct Lake falls back to DirectQuery

    01:53

  18. 1801:58

    How does Power BI integrate with the rest of Microsoft Fabric

    01:58

  19. 1902:03

    What does Data Factory in Microsoft Fabric provide, and how does it relate to Azure Data Factory

    02:03

  20. 2001:53

    Difference between a Data Pipeline and Dataflow Gen2 in Microsoft Fabric

    01:53