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.

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

Hi pthapa , 

What is the size of dataset? If the volume of dataset is high and then we need to go for incremental refresh.

There are some workaround too which can be done without incremental refresh enabled.

  • We can keep 2 tables in power bi, one table we can disable refresh and other table refresh 2 weeks data. Combine these 2 table for reporting. can you try this and let me know if facing any issue. Please do share the sample pbix file so can provide details solution.

Thanks,

Pallavi