This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
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
Solved! Go to 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.
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.
Thank you!
This has got the ball rolling on the problem.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 25 | |
| 24 | |
| 22 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 52 | |
| 48 | |
| 47 | |
| 22 | |
| 21 |