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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

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.