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 I don’t think it is possible to use native queries in Direct Lake mode like in Import or Direct Query. Instead, you can create filtered Delta table views or shortcuts at the Lakehouse level.You could also preprocess data using Fabric Dataflows or Notebooks for refined subsets.