v-pranithab's avatar
v-pranithab
Microsoft Employee
1 month ago
Status:
New

Enable Incremental Refresh Support for Native SQL Queries Without Query Folding Constraints

This would allow customers to leverage Incremental Refresh without redesigning existing SQL-based solutions into views or functions, reducing complexity and improving adoption.
power bi

2 Comments

  • frithjof_v's avatar
    frithjof_v
    Community Champion
    1 month ago
    Have you tried using Value.NativeQuery with EnableFolding?
  • Gautam_Kumar01's avatar
    Gautam_Kumar01
    Post Partisan
    1 month ago
    Fully support this idea v-pranithab We faced the same blocker while migrating our reports. Right now we have to rewrite all native SQL into views/functions just to enable Incremental Refresh, which takes a lot of extra time. Supporting native SQL directly without query folding constraints will make adoption way faster for enterprises with legacy workloads. +1 from a Fabric Advocate and student community

Recent ideas