Forum Discussion
Incremental Refresh Using Stored Procedure, Parameters Not Overridden in Power BI Service
- 1 year ago
correct. They don't know anything about the query that runs on that table. Don't use them, find another way, for example via the data model.
- 1 year ago
I found this workaround. Re: incremental refresh on table by reference - Microsoft Fabric Community , which fixes the issue by passing the incremental refresh parameters to dummy variables in the reference table queries. With the dummy variables in the reference queries, Incremental Refresh configurations can be applied (there will be a warning that query folding can't be confirmed). After publishing and refreshing, all tables now have partitions and the correct amount fo data.
Thanks, this knowledge helped me to discover a workaround.
Don't do it. Get rid of the need for these tables. The "may not fold" warning has a reason - you may negate the performance benefits of the fully folded incremental refresh, and all you get is partition management.