Forum Discussion
Does Incremental refresh works with SQL stored procedures?
2 Replies
I don't see why it would not as long as you have a proper column to use to flag as incremental.
I think the issue is that incremental refresh needs query folding to occur, which I don't think works with stored procedures. Otherwise, it will execute the whole SQL query which kind of defeats the point of incremental refresh.
It seems a bit crazy, as there must be many dashboards built using stored procs with parameters
