Forum Discussion
Direct Lake over Mirrored Database
Can we have a Direct Lake mode semantic model against a Mirrorred Database in Fabric? The Direct Lake docs indicate that it uses a SQL Analytical endpoint as a source. And the Mirroring docs indicate...
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!
The Direct Lake docs indicate that it uses a SQL Analytical endpoint as a sourceNot primarily. The preferred option is to go to the Delta Lake files directly, only if your query becomes too complex would it fall back to Direct Query mode.