Forum Discussion
Tlakhani
1 year agoNew Member
Need help with Append query
Hello All, I have a requirement as below: connect SQL server script to PowerbBI get the data - this has to refresh twice in day store every day 2 data set in one sheet in powerbi or excel -...
- 1 year ago
Hi Tlakhani
You can use Power Automate to save snapshots of changing metrics and then load them into reports that track the historical progress of those metrics. More details in the linked video.
https://www.youtube.com/watch?v=ZTkbC8zhA5kIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983
1 year agoSuper User
Hi Tlakhani
You can use Power Automate to save snapshots of changing metrics and then load them into reports that track the historical progress of those metrics. More details in the linked video.
https://www.youtube.com/watch?v=ZTkbC8zhA5k
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly