Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |