Forum Discussion
Solved
Incremental refresh - Staging tables
I bet this is common to everyone who is doing incremental refresh in Power BI and I could not find a better solution. I have two tables (A, B) in my relational warehouse which I import them to the ...
Hi anilthapa11 ,
check out this blog post.
https://community.powerbi.com/t5/Community-Blog/Incremental-Refresh-with-Subqueries/ba-p/1003337
Hi anilthapa11 ,
- 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.
- 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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi anilthapa11 ,
- 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.
- 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.