Forum Discussion
Help with creating and storing data snapshots from Microsoft Intune
Hi Vinxsta ,
You're right that the OData feed from Intune only gives you the current state of the data, so for historical tracking you'll need to implement your own snapshot logic.
One common approach is to use a scheduled pipeline (like in Azure Data Factory or a Logic App) that pulls the data from the OData feed on a weekly basis and stores it in a blob container or a data lake. You can store each snapshot as a separate file (e.g. JSON or CSV) with a timestamp in the filename.
Then, in Power BI, you can connect to that storage and build a model that reads all the snapshots and lets you do trend analysis over time.
Another option is using a Fabric Dataflow Gen2 to pull the data and land it into a Lakehouse table weekly. That way you can keep everything inside the Fabric ecosystem.
Hope that helps get you started.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI
What solution did you go for in the end?
I have almost the exact requirement and I am trying to figure out the best way to tackle it.
I'm wondering if I should create a new table with a row containing the compliance data values and a date. Somehow automate a job to add the current data values on 1st of each month, then create a report/dashboard using that.
I only need to store the totals, not compliance for each device.
