Hi everyone! This task seems easy but I can’t seem to find a proper way to set this up.
I have an excel file that I need to run through dataflow once a month. I’m running the flow because I need to use power query to join with a SharePoint list in a process. So basically taking a monthly snapshot of that excel data + SharePoint data together. Next month I need to do the same for just this month, and store it in the same data verse table.
when I try to just load new excel file into my dataflow it runs just fine but as a result I get duplication or already existing records and then it adds those new records for the new month on top of it (that if I don’t have “remove rows that don’t exist in a query output”)
if I have that mark checked, previous months data gets deleted and my final data verse table only has records for this months, which is also incorrect.
please help, it really seems like an easy task but for some reason I can’t seem to understand what to do here
