Keep/snapshot historical data in the report

[mariella2]

Hi all,

I have a Power Bi report, which is connected to a Sharepoint list. Some fields in the Sharepoint list are changed overtime, therefore the report changes as well. I would like to know if there is an easy way to keep a snapshot of the current data either in Power Bi or Sharepoint, so that I can compare it with the new ones. 

Thanks in advance for your support.

[MFelix]

Hi @mariella2 ,

If your report is connected to the Sharepoint list since you have an update of the list you get only the last information since Power BI is a "read only" system so it doesn't have the ability to store data beyond a refresh.

To have this historical data you would need to save the data after update, maybe trying to have a incremental based on the updated date.

Check this blog post.

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...