Issue saving data

[Vampirtc]

Project is the following:

extract data from outer sources every week

display them in a worksheet

with the help of data manually process the data and change/add data

the hard part: save that data and use in the next week report
keep using reports from every past week

The data are just numbers and can be tied to a unique ID.

How would you make this project? Extracting and displaying data is not a problem.

[Icey · Accepted solution]

Hi @Vampirtc ,

How about saving weekly data into a seperate folder and then setting to refresh data only in this week and keep the historical data?

You can refer to this blog:

Incremental refresh for files in a Folder or SharePoint - Power BI — Powered Solutions

Best Regards,

Icey

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

[Jimmy801]

Hello @Vampirtc 

in Excel you could write a Macro where you after every refresh writing the data to another table and adding the date of refresh. Then you could use this historical table for your process.

Hope it helps

BR

Jimmy