Forum Discussion
DirectQuery Semantic Model
Hi Anonymous ,
Your semantic model configured with Direct Lake will fallback to DirectQuery mode by default whenever a DAX query exceeds the limits on a SKU or uses features not supported by Direct Lake mode, such as SQL views from the Warehouse.
In Direct Query mode, the query retrieves data directly from the SQL analytics endpoint of the lakehouse or warehouse.Such queries always return the latest data because they're not constrained to the point in time of the last framing operation.Live connection is a method that lets you build a report in Power BI Desktop without having to build a semantic model for it. When you create your report in Power BI Desktop, you can connect it to a semantic model that already exist. Since, you already have a semantic model to connect, it shows live connection.
You can read more about Direct Query fall back and Fabric capacity guardrails and limitations in following link:
https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview#directquery-fallback
https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview#fabric-capacity-guardrails-and-limitations
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it
Hi @dimitragav10_ ,
Just wanted to check if you had the opportunity to review the information provided ?
If the response/s has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.