How to Append Data in Power BI Exports Using Power Automate Without Overwriting the Existing File?

[power2]

I have a Power BI report that's pulling data from an excel file on the Sharepoint. That excel file gets updated frequently, 5-10 times a day, and then some rows get removed and some added. So, if I want to keep an historic data in one my reports, I will have to get a snapshot of this excel file every hour or something.

Already created a Power Automate flow to do that and it's working well. However, everytime its taking a snapshot of the data, it saves it in the same Sharepoint folder and replaces the previous one. How can I append data to this export file instead of overwriting it?

I need to keep only 1 file with the same name so having a different snapchost csv for every export is not feasible.

Help!!!

[lbendlin]

You may want to ask that question in the Power Automate forums.

Might be as easy as including a timestamp in your Excel file name.

And no, you cannot do this with Power BI. Snapshot management needs to be done further upstream.