Data Snapshot

[sameergupta60]

hi,

please provide a solution on how to take a snapshot in power BI every week of the value change.

if 20/04 2021 data showing amount data & after next week on 26 /04/2021 new amount will be reflected.

the working file is a single week on week I have to update also capture previous week data in the snapshot

sample file attached for your reference. please provide a solution on snapshot data file will be excel.

Start	Zone	Project	Vendor Name	P Bills Amt	O days	Not yet due	30 Days	30  60 days	60  90 days	90 Days
20/04/2021	XY	Z	C	0.01	12	-	0.01	-	-	-
20/04/2021	XY	Z	C	0.00	12	-	0.00	-	-	-

[v-yuaj-msft]

Hi @sameergupta60 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Yuna

[v-yuaj-msft · Accepted solution]

Hi @sameergupta60 ,

Please refer to the following link if it can help you.

Scheduled Snapshot of the Power BI Data and Report - RADACAD

Note:

While Microsoft supports and encourages open-source software development, it does not provide technical support for the software from third parties, nor does it guarantee that the software will work as described.

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.