Incremental refresh - Staging tables

Hi anilthapa11 ,

check out this blog post.

https://community.powerbi.com/t5/Community-Blog/Incremental-Refresh-with-Subqueries/ba-p/1003337

Hi anilthapa11 ,

1. Since Table C is referenced from Table A and Table B, both of them cannot be deleted as your previous said. If you don't want to show them in Fields pane, hide table may be a best way to do this.
2. About set incremental refresh on Table C, I think you can just configure incremental refresh on Table C without setting Table A and Table B at the same time bacause Table C is now a single independent table and the parameters RangStart and RangEnd are public to use in the same report in power queries. You should use these two parameters and filter the date column on Table C configure incremental referesh on it and it should work fine. For more information about parameters in incremental inrefresh, please refer the microsoft document: https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.