Forum Discussion
how to archive data
I have pro licence . I want to store data every month as historical data. I know incremental refresh can do but I dont have preimum licence. what is the best way to store data. I want to run to get n...
Thanks for your response. I want my data to get refreshed every day but when period ends it should store data no more changes after perid ends. Then I want my new data to refresh for new period every day then next period comes to end then it should store to previous data. It should contiue for every period. I hope you understand
I'm not quite sure I'm following the idea of the periods, but you can check this videos that will show how to set up your incremental refresh.
https://www.youtube.com/watch?v=BQahH53ayKU
https://www.youtube.com/watch?v=Kui_1G6kQIQ
I hope that helps,
1/1/2023 to 1/31/2023 period 1
2/1/2023 to 2/28/2023 period 2
3/1/2023 to 3/31/2023 period 3
....... so on