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

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

ScripTeapot_ — Mon, 22 May 2023 15:29:44 GMT

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.

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

Anonymous — Wed, 24 May 2023 05:54:57 GMT

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