Forum Discussion
Post PatronHow can I keep historical data in Power BI?
Post PatronHello 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
- collinq
Super User
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
Any idea why I am getting 'A cyclic reference was encountered during evaluation' upon applying filter on datetime field with RangeStart and RangeEnd parameter in PBI?
Source of my data is sql server and using stored procedure.
thanks,
pthapa
- pthapa
Appreciate your input.
Thanks,
pthapa