Forum Discussion
ankilo2011
Sep 25, 2023Copper Contributor
API Query Results Different from Azure Portal
Hello Team, i 'm running a query that i have connect an API with excel. The results for example for a specific user for a specific a day for a conditional access that blocks legacy authentication ...
Kidd_Ip
Feb 23, 2026MVP
For purposes of compliance, auditing, and automation, the Microsoft Graph API should be regarded as the authoritative source of sign-in and conditional access data. While the Azure portal provides a convenient interface for quick inspection and monitoring, it applies certain filters and visual simplifications. In contrast, the API delivers the complete dataset without user interface–level adjustments, ensuring full fidelity for reporting and analysis.
https://learn.microsoft.com/en-us/entra/identity/monitoring-health/concept-sign-ins
https://learn.microsoft.com/en-us/entra/identity/monitoring-health/howto-analyze-activity-logs-with-microsoft-graph
Learn about the sign-in log activity details | Azure Docs