How to Accumulation the Data that get from dataflow

[Lopez0090]

---------------------- Current status ----------------------

１．Create a report using DataFlow as a data source

２．Publish the report to the Power BI service (Workspace)

３．Dataflow data is overwritten and updated daily（Old data will be deleted when updated）

---------------------- What you want to achieve ----------------------

I want to accumulate Dataflow data that is updated daily.

The ideal save destination is Excel or Azure SQL Database, but can it be realized with Power Automate?

[V-lianl-msft · Accepted solution]

Hi @Lopez0090 ,

Please refer to this bolg:

https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.