Storing Historical Data in Power BI

[Pulkit]

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.

[v-frfei-msft]

Hi @Pulkit ,

Hope this case could help you.

[sananthv]

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.