Forum Discussion
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 - for further analysis
I was able to connect sql and refresh data twice - but unable to take backup or store the historical data - any suggestions or ideas?
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
1 Reply
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