Forum Discussion
Solved
Is Native Query Support Available in Fabric's Direct Lake Mode (Similar to Import or Direct Query)?
Hi everyone, I’m currently exploring Microsoft Fabric and using Direct Lake mode for Power BI datasets. In Import and Direct Query modes, we can define native queries (SQL queries or custom views) t...
mohita98 As the most answers point to the same solution could you please accept this as a solution so as others could find this easily
Hi mohita98
In Direct Lake mode, you can’t write custom SQL queries the way you can in Import or DirectQuery modes. Direct Lake is built for fast, real-time access to Delta Lake tables without moving data, which means you can’t pre-filter data through native queries.
Instead, create views or shortcuts at the Lakehouse level with only the data you need. Power BI can then connect to these in Direct Lake mode, letting you control the dataset’s scope while keeping the performance benefits.