Incremental load of daily excel file to exisiting history table in Power BI

[CheenuSing]

Hi All,

I am having a scenario like this.

1. I have loaded the historical data from an excel file folder.

2. I have in another folder only previous days data in excel in the same format as the history data. There will be only one file in this.

3. I want to append the file in 2 to the file in 1.

The challenge I am facing is next day when a new daily excel file is loaded in the new data folder, it is only appending the new data. The data of yesterday is lost.

How to over come this.?

Is there a way where by I can store back the updated data into the historical data folder, which i reload on a daily basis and then append the new data to it.

Does the incremental load feature introduced in power Bi can help achieve this. If so how to do this ?

Cheers

CheenuSing

[Greg_Deckler]

Not sure incremental load will help you. I would think that when you put the previous days data into the folder you will need to move the existing file in that previous day folder to the historical folder. Then you should be OK.

[Anonymous]

Fairly certain incremental refresh won't help you in this scenario.  It works by creating a set of partitions to facilitate the incremental loading.  From what i've seen you need to have the query folding active for it to even work.  I can't see Excel files support that.