Forum Discussion
Capture Weekly report (Last week and This Week)
Dear I have page that contains upto 15 visual and data souce have excel file(upto 50 column and no date column), updation of excel file like adding new row or updating data to existing cells on ...
HI Anonymous,
AFAIK, current power bi does not support cache the historical data.
For this scenario, I think you may need to use a temporary database to import the history records and remark the input date. (check the id or other unique value field in your sheet and compare with existing DB records to remark the input date) After these steps, you can simply use power bi to get data from that database and design visualization reports.
Regards,
Xiaoxin Sheng