- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need to freeze the data from one source each monday and store it in a new table with an id
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

Helpful resources
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
4 | |
4 | |
4 | |
3 |