I need to freeze the data from one source each monday and store it in a new table with an id

[ScripTeapot_]

It's pretty much what I said in the title; I have a data source from sharepoint and each monday I need to freeze that data and store it in a new table for future references, so I need some ID to identify the week. I don't really know if I'm able to do this in Power BI or if I need something more.

[Anonymous · Accepted solution]

Hi @ScripTeapot_,

Current power bi does not include historical data feature. I think you need to export these daily records to standalone files or try to saving these daily records to a temp database with correspond timestamp, then you can simply use power bi to get data and analysis with stored records.

Regards,

Xiaoxin Sheng