Forum Discussion

Sparkdata's avatar
Sparkdata
New Member
10 hours ago

Direct Lake vS Direct Query

Came across this, has some deep insights.

i personally find Direct Query more flexible, what do you all prefer ?

 

https://medium.com/@rishabh.gulati_94109/microsoft-fabric-direct-lake-is-fast-good-data-architecture-is-faster-340276de2e6b

data engineering
data pipeline
lakehouse
notebook

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 hours ago

    Hi Sparkdata​ 

    I personally prefer direct lake and the reason for that is that you still have to build this task schema with facts and dimension tables which align to business intelligence or data engineering and insights into your data, especially if you start using the AI on top of it. Whilst having things in Directquery this is often not the case and it makes getting out. The data you need for AI and reporting a lot more difficult.