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