Solved: Need help with Append query

Tlakhani · ‎09-06-2024

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 · ‎09-07-2024

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Ritaf1983 · ‎09-07-2024

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile