Refresh only a part of a merged table

[qwertzuiop]

Hello Dear Power BI Community

Following problem to solve:
In this business context, Excel files are read in every six months and have an hug size.

The semi-annual tables are then merged in the Power Query Editor in Power BI.

Consequently, I want to prevent all tables from being updated during a refresh, only the current six months.

For illustration the following simplified example

Let's assume we habe two tables (Jan-Jun_2022, Jul-Dez_2022)

I now merge these two tables into one.

Since they have the same structure, this is no problem at all.

For the first table I have disabled the settings that this should load during an update

This works as far as possible, but when the merged table is updated, the first table (Jan-Jun_2022) is updated as well.

Hope you get it guys.

Thank you very much for your contribution.

Cheers

qwertzuiop

[MFelix · Accepted solution]

Hi @qwertzuiop ,

The Disable options does not avoid your table from being refresh it just makes it not load the data into Power BI in this case since it's being used on another table you see it when it's refresh.

To make this partial refresh make you need to use incremental refresh, however be aware of how you implement it because it can give you some others issues if the setup is incorrect.

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

https://www.sqlshack.com/an-overview-of-power-bi-incremental-refresh/