Forum Discussion

billyrich83's avatar
billyrich83
Frequent Visitor
2 years ago
Solved

Monitoring workload

Hi all,  I've been tasked with monitoring our team's workloads, especially those jobs that have been with us for a certain amount of time and have not been addressed.    I'm looking to create a re...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi billyrich83 

    Unfortunately, in Power BI, there is no option to save snapshots of calculated data that is refreshed periodically.

    This means that it is not possible to compare a report before a refresh to a report after a refresh to alert that the data has not changed.

    What can be done is to export the data to Excel using Power Automate and then load it back and perform the comparisons.

    Check this guide if it can help:
    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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi billyrich83 

Unfortunately, in Power BI, there is no option to save snapshots of calculated data that is refreshed periodically.

This means that it is not possible to compare a report before a refresh to a report after a refresh to alert that the data has not changed.

What can be done is to export the data to Excel using Power Automate and then load it back and perform the comparisons.

Check this guide if it can help:
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

billyrich83's avatar
billyrich83
Frequent Visitor
2 years ago

Hi,

 

Thanks for the response.

 

I will have a play about with this and see if I can get it to work for me