Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 report listing the jobs assigned to each project manager. This report will be refreshed once a month, and I was wondering if there is a way for the report to flag up if the status of a job hasn't changed since the last refresh.
I hope this makes sense. Thanks in advance.
Billy
Solved! Go to Solution.
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
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
Hi,
Thanks for the response.
I will have a play about with this and see if I can get it to work for me
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |