Forum Discussion
Track Weekly Deployments From SharePoint List
It depends on what they mean by "track deployments on a weekly basis" - if they just want to know how many deployments completed in a given week, assuming you have a date field for the completed date of the deployment, you could just group that into weeks in a visual using a date table. Date tables are completely worth learning if you haven't used them before.
But if they want snapshot-ish history based on how the records looked at a particular point in time, that's a going to be a lot more convoluted - you'd need to have something record that data. A Power Automate flow on a schedule would be a good place to start with that, but honestly that kind of tracking isn't usually worth it for small sources.
The snapshot-ish history is what they are looking for. The completed date field is not populated until ALL deployments for a particular location are complete, but the Devices Deployed field is updated as the devices are deployed, so it changes almost daily.
You can orchestrate a dataflow Gen2 from a Data Factory pipeline on a weekly schedule, and have the dataflow materialize the snapshots in OneLake. Everything you need is in Fabric, no need for Power Automate.
I have a technique here for snapshotting SP lists for PBI - this is more of a non-premium, low-code, anyone-can-do-it option. Otravers suggested the more robust, engineer-y Fabric option if you have Fabric to work with.
