Adding data from continulously refreshed Table A to historical data Table B.

[LSeitz]

I'm moving from SAS to Power BI, so trying to convert the coding the best that I can. 

In the SAS program the data for the current week is refreshed multiple times a day, after the week is complete the data is moved to a table that is not refreshed anymore but all historical data is stored. A combined table of all the data is used for reporting purposes for it to be able to view current and historical. 

Is there a way in power bi to have Table A be continulously refreshed data, Table B is be historical only, and Table C be combined of both A and B to show on reporting dashboards. Once data in Table A is no longer in the allowed refersh timeframe it is moved to Table B, Table B is too large to also be continulously refreshed and data sources only hold a year of data, but all historical data is wanted. Is there a way to added data from Table A to Table B without refreshing all of Table B? OR to be able to make Table C into Table B but delete data that would be overlapped with Table A?

[lbendlin]

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

This supports "Today"  Direct Query partitions too.