Question

Your organization wants a business analyst to build custom historical trend reports on Intune device compliance over the past 60 days using Power BI. The analyst needs to connect to a data source that exposes historical Intune data spanning multiple snapshots rather than only current-state values. Which approach should you use to provide this data?

Accepted Answer

Connect Power BI to the Intune Data Warehouse OData feed URL

Answer

Export the current device compliance report to CSV from the Intune admin center and import it into Power BI

Answer

Use a device query in Intune to return compliance state and paste the results into Power BI

Answer

Configure a Log Analytics diagnostic setting and query the current compliance table with KQL