Doubt in Excel and PowerBI

[manas0806]

so i have one folder named

Monthly Reporting Dashboard

-- HR1 --> contains many .xlsx files

--UAR1 --> contains many .csv files

-- Combine1 --> contains single HR_UAR_combined.xslx file in which there is combination of excel files present in both HR1 and UAR1 folders



So currently the HR_UAR_combined.xslx file is live and actively connected to dashboard, but as soon as we delete something from HR1 and UAR1 folders it affects the combine1 folder's excel file and dashboard as well, i want to avoid that.


I have to achieve:


Currently there is query written for combining the excel sheets from both the HR1 and UAR1 folders, and when we paste the excel file in any of the HR1 or UAR1 folder and it gets appended to combine1 folder's excel file, the pasted excel file from HR1 or UAR1 should be deleted without affecting the appended data in HR_UAR_combined.xslx and dashboard as well.


basically excel data once it gets append to HR_UAR_combined.xslx it should not be present in either HR1 or UAR1.

how can i achieve this? I am stuck!!