Forum Discussion

Vinxsta's avatar
Vinxsta
Frequent Visitor
1 year ago
Solved

Help with creating and storing data snapshots from Microsoft Intune

I currently use Power BI to connect to Microsoft Intune via an Odata feed. As it stands, the data I see in Power BI is what is currently in Intune and this changes daily. What I want to do is firstly...
Need Help
Blue407's avatar
Blue407
Frequent Visitor
11 months ago

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.

  • Vinxsta's avatar
    Vinxsta
    Frequent Visitor
    11 months ago

    Hi Blue407, I ended up connecting to my odata feed using Microsoft Fabric and setting up a scheduled flow. I append each weeks' data into one table with a new column to recognise the snapshot date. This works fine for me. Hope this helps you.