Forum Discussion

power2's avatar
power2
Frequent Visitor
2 years ago

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

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!!!

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.