How to append new excel file to exiting excel file in power bi using Auto refresh ?

[v-qiuyu-msft · Accepted solution]

Hi @Sac,

You can place those Excel files in one folder, then in Power BI desktop, connect to this folder via Folder data source, use Combine Files feature. Please note the Excel structure need to be the same, eg: table name and column name. See:  Combine binaries in Power BI Desktop.

When you receive the new Excel file, you can put it in this folder. Refresh in desktop you can get data both from old files and new file. After publish to service, you need to create a Folder data source under data gateway then configure the dataset to use this data gateway.

Best Regards,
QiuyunYu

[GilbertQ]

Hi @Sac

Can you please provide more details around what you are wanting to do?

If it is another file that you want to append to an existing file, in the Query Editor there is an option to Append the data together.

[Sac]

Dear,

Actually i want to set up auto refresh.  I am working on the project in which suppiler sends us report in excel file every month. I already make model and dashboard. Now Quetion is .

Next month , when i got a new excel file from suppiler then i want to set up auto refresh and the data of that new excel file will append to my exiting excel file in power bi .

[GilbertQ]

Hi @Sac

Is it going to be a new file or overwrite the existing file?

If it is going to overwrite the existing file then on refresh it will load all the contents of the file. So your historical data if not contained within the Excel file will get lost.

[Sac]

No. Actually i want to keep my historical data as it is and append only new data to that file.  Do you have any way to do this  other than this  ?