Intune Data Wharehouse not updating all data

Question

We have couple of devices in Data Warehouse not updated. For example, when I look Intune web UI for a particular device, lastsynctime is accurate and we see that it has the latest OS version (iPhone with iOS 18.3.1). However, when I look for this device in Data Warehouse through PowerBI OData connection, it is still an old version and it says the device lastsynctime is more than 3 months old.

Is something can be done to fix this?

Note:

-99% of devices are accurate

-For that particular example, I made sure it is the right/same device by validating with the deviceID.

Answer 1

@Pascal Richard, Thanks for posting in Q&A.

For your issue, it is probably due to a delay or hiccup in how the Data Warehouse refreshes data for certain devices. Although 99% of your devices are updated correctly, for that small percentage the following could be at play:

Intune Data Warehouse is designed to update daily, but on rare occasions some devices can “stick” with outdated data.

Even if the device is reporting properly to Intune, sometimes its data feed (via the OData connection) doesn’t update as expected. This can be due to transient errors or a known bug affecting a handful of devices.

So, please Verify (again) that the device’s enrollment and sync logs in the Intune portal are healthy. And if possible, trigger a manual sync from the device and wait for a few hours to see if that pushes an update into the Data Warehouse.

Please try above information, if there is any update, feel free to contact us.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.