Forum Discussion

pthapa's avatar
pthapa
Icon for Post Patron rankPost Patron
2 years ago
Solved

How can I keep historical data in Power BI?

Hello Experts, What is the best way to keep the historical data in PBI? It seems like incremental refresh in PBI might do the job however, wanted to check with all experts in PBI. Is there other b...
Need Help
  • collinq's avatar
    collinq
    2 years ago

    Hey pthapa ,

     

    Based on your response, incremental refresh will probably be the best option.  You can use incremental refresh on any date/time field.  Just be sure to understand the "policy" part of the incremental refresh to make sure it is getting the right time period.

collinq's avatar
collinq
Icon for Super User rankSuper User
2 years ago

Hi pthapa ,

 

I am wondering what you mean by "keeping historical data"?  Does this mean that the older data gets modified but you do not want to change it from what it was?  Or, do you mean that the older data's data source is eliminated and if you have not saved that then it is gone forever?  

Since you mentioned incremental refresh - do you just mean that you want to keep adding the new data from the same data source and that data source does not every "remove" or "lose" older data?