Snapshot fact table where data is deleted

[Tomhayw]

Hello everyone,

I have a table that has rows regularly added and removed from it.

Once a day, I want it to take a snapshot of what it looks like at that specific moment in time, and be able to pull this into an excel sheet or somewhere where I can then analyse it again in PowerBI.

Sample data (Figure 1):

Desired result (Figure 2):

However, the key thing to remember is that projects in Figure 1 may be removed, so it would have to save the data somewhere.

My initial thinking is that I need a way to essentially download a summary of that data, which I can then re-pull back into PowerBI to do further analysis.

Any resources or help would be great

Thanks,

Tom

[davehus · Accepted solution]

Hi @Tomhayw ,

You could use Power Automate for this. Check out this video from Curbal.com 

https://www.youtube.com/watch?v=wy1BE1TJ_jc&ab_channel=Curbal

Did I help you today? Please accept my solution and hit the Kudos button.

[Tomhayw]

Thank you!

This has got the ball rolling on the problem.