Forum Discussion
Append data from dynamic daily refreshed data
Good afternoon. I am trying to append data from a csv file that is refreshed daily. What I am trying to have is a accumulalive table that will keep all data and only add (append) the new data. ...
Power BI doesn't store data like that. In your case, I would set up a Flow to name and store your daily csv files (choose a name that incorporates the date so you can use it downstream), and have Power BI combine all the CSVs. If the csv is emailed to you, you can trigger the flow based on that. If manual, you could rename it (with date info) and store in a SharePoint or OneDrive location for easy refresh from Power BI.
Regards,
Pat
That is how I do It but it is no reliable a practical a the data is about 32,000 records daily and if you miss to do the store and renaming process I loose the entire day. Data is refreshed daily at 12:00.
It looks I will help for the SQL guys to to develop a query.
Thank you so much!