Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ahmad1111
Frequent Visitor

Archive function

i want to ask how could i create a new table i will call it archive and then have my all of my other tables that have data to move those data based on passing 10 days from creation date so for example my structure is ASN # , event, Created on date 

and lets say i will say that todays date - created on date will give the number of days difference based on that if its more than 10 days ill just have it moved automatically should detect the table by itself this record and push that row of data in my table to the archive table if someone can help with this 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @ahmad1111,

AFAIK, current power bi does not include historical data feature, so you can't directly achieved archive old data feature in power bi.
I'd like to suggest you setting a batch on data source side to achieve these or export data to a temporary database which include backup features, then you can use power bi get data from this.

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

HI @ahmad1111,

AFAIK, current power bi does not include historical data feature, so you can't directly achieved archive old data feature in power bi.
I'd like to suggest you setting a batch on data source side to achieve these or export data to a temporary database which include backup features, then you can use power bi get data from this.

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.