DP-600 · 3.2.4 · Implement and manage semantic models
Direct Lake options
Choose between Direct Lake on OneLake and Direct Lake on SQL analytics endpoint
Choose for direct multi-item access without , or the SQL-endpoint option when endpoint security and compatibility matter.
Same Delta data, different access path
reads supported directly through , can combine supported Fabric items, and never falls back to .
is tied to one Fabric source. The endpoint participates in discovery and security checks, and unsupported queries can fall back to DirectQuery.
Choose the SQL-endpoint path when you depend on endpoint behavior such as SQL-level security or views. Choose OneLake when direct access and multi-item composition are the priority.
Key points
- : direct Delta access across supported Fabric items
- SQL endpoint: one Fabric source with endpoint checks
- : only the SQL-endpoint option can use
- Security: OneLake and SQL-endpoint paths enforce different layers
Click an underlined term for a one-line explanation, or see them all in the glossary .
Exam trap
The SQL endpoint does not normally serve column data. It handles discovery and security; data queries reach it only during .
Sources · 3 Microsoft Learn pages Show ▾
- Direct Lake overview (Microsoft Fabric)
- Develop Direct Lake semantic models (Microsoft Fabric)
- How Direct Lake works (Microsoft Fabric)
Checked on October 4, 2026. Report a problem
Go deeper on Microsoft Learn
- Direct Lake overview (Microsoft Fabric)
- Develop Direct Lake semantic models (Microsoft Fabric)
- How Direct Lake works (Microsoft Fabric)
Checked against Microsoft Learn on October 4, 2026. Report a problem with this card