Forum Discussion
Direct Lake over Mirrored Database
Hi Anonymous
No, the fallback to DirectQuery in Direct Lake mode only works when the semantic model is built over a Lakehouse.
While mirrored databases do expose a SQL Analytics Endpoint, they are not supported as sources for Direct Lake models, and therefore cannot be used for Direct Lake fallback.
Only the SQL Analytics Endpoint of a Lakehouse is used when Direct Lake falls back to DirectQuery.
Thank You!
Hi Anonymous
Thank you for reaching out to the Microsoft Fabric Community Forum.
As correctly pointed out by lbendlin that Direct Lake mode prefers reading from Delta Lake files directly, and only utilizes the SQL Analytics Endpoint as a fallback mechanism.
While the SQL Analytics Endpoint is part of the overall setup, Direct Lake mode does not primarily query from it. Instead, it reads directly from the Delta Lake-formatted files stored in OneLake, which allows for high-performance, near real-time analytics.
The SQL Analytics Endpoint is only engaged when a query becomes too complex or uses unsupported DAX features, at which point the engine gracefully falls back to DirectQuery mode.
For more detailed guidance, please refer to the official Microsoft documentation:
Direct Lake overview - Microsoft Fabric | Microsoft Learn
If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank You!
Thank you, lbendlin and v-karpurapud for the replies. Perhaps I should have phrased my question better. 🙂
When the queries need to fall back to using the SQL Analytics endpoint, is the one created with a Mirrored Database supported for that fall back?
Thanks.
Hi Anonymous
No, the fallback to DirectQuery in Direct Lake mode only works when the semantic model is built over a Lakehouse.
While mirrored databases do expose a SQL Analytics Endpoint, they are not supported as sources for Direct Lake models, and therefore cannot be used for Direct Lake fallback.
Only the SQL Analytics Endpoint of a Lakehouse is used when Direct Lake falls back to DirectQuery.
Thank You!Thank you, v-karpurapud That is what I was looking for.