Forum Discussion

Pulkit's avatar
Pulkit
Icon for Resolver I rankResolver I
7 years ago

Storing Historical Data in Power BI

Hi All,

 

My DB only keeps the last 6 months data in it but I want to analyze the last 12 months data. So, is it possible that I keep the data stored in Power BI itself?

I can load the first 6 months data in Power BI and keep it out of refresh package but then how should I update the table?

Any suggestions are welcome.

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • sananthv's avatar
    sananthv
    Icon for Helper II rankHelper II
    7 years ago

    I am not sure if this will work, but give it a try and see. If you have a field called last updated timestamp or something like that in your table, use dataflows with incremental refresh (dataflow, as that will give you access to a massive gen2 datalake). This will keep adding data. Then use link entities to modify the data to the format you want.