Forum Discussion

Tlakhani's avatar
Tlakhani
New Member
1 year ago
Solved

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 -...
  • Ritaf1983's avatar
    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=ZTkbC8zhA5k

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly