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.

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

Hello collinq,

Thanks for your concerns on my topic. Here are my comments.

What I mean by keeping historical data is that; yes, my data changes over time and I only want certain time lenght of data to change not the entire 2 years of data in power bi keeping hisotocial data.

No my older data will not be eliminated. 

Not sure if I understood your last question, here are my thoughts to that;

Yes, I want to keep 2years (or maybe more) data to store in pbi however not refreshing all 2 years of data when data refreshes. My older data on the source will not get removed. I want to keep getting 2 years worth of data and only allowing 2 weeks of data to refresh. This  is exactly performed in incremental refresh. 

I am wondering if there is other options available that might be better; that's all.

Hope I answered your concerns.

Thanks

pthapa

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

Appreciate your input.

Thanks,

pthapa