Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
data engineering
Lakehouse
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    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!

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you, v-karpurapud That is what I was looking for.