I connected to semantic model created on Datalake on OneLake but see that DirectQuery is fired!

[jaryszek]

Hello,

I made steps from this tutorial:

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-direct-lake-on-onelake-and-creating-direct-l... 

And created new report, 
connected to live semantic model from power bi desktop, run performance analyzer and saw:

So why this is turning automatically into SQL ENdpoint? 

I do not want to use Direct Query, it was not a purpose of this feature!

Best,
Jacek

[v-prasare]

Hi @jaryszek,

Please refer to this doc for more insights related to Direct lake sematic models and let me know if this helps?

https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-manage

Thanks,

Prashanth

MS Fabric community support

[v-prasare · Accepted solution]

Hi @jaryszek,

Thanks for your patience here.

By default, semantic models in Fabric are set to DirectLakeBehavior is Automatic, which means: Try Direct Lake first. If not possible, fall back to SQL Endpoint (DirectQuery).

If the queries inside sematic model includes functionality not yet supported in Direct Lake (e.g., certain DAX functions, relationships, calculated columns/measures, row-level security), the engine automatically falls back to SQL Endpoint.

That’s why you’re seeing DirectQuery queries in your analyzer.

Thanks,

Prashanth Are

MS fabric community support

[jaryszek]

what does it mean ? I open to be hired by Microsoft and work on it with you 😉