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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have a similar problem. My data source is a published PowerBI dataset and is connected using a direct query. However, I want to maintain historical views to compare current data with historical statuses. Any idea how this can be achieved in a scenario like this ??