Need help with Append query

[Tlakhani]

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?

[Ritaf1983 · Accepted solution]

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