Forum Discussion

RobFlanders's avatar
RobFlanders
Frequent Visitor
9 years ago

Azure AD Reports API

I am trying to connect to the Azure AD reporting API to extract Azure AD security reports. Reports are made available through the Azure AD Graph API. I can connect to some services on the API but not the new reports. Has anyone hooked Power BI up to the reports endpoints in AAD Graph API?

 

AAD Graph API example request which I can pull data from:

https://graph.windows.net/[Tenant]/activities/audit?api-version=beta

 

AAD Graph API endpoints I would like to connect to:

https://graph.windows.net/<tenant-name>/reports/CompromisedCredentialsEvent?api-version=beta
https://graph.windows.net/<tenant-name>/reports/IrregularSignInActivityEvent?api-version=beta
https://graph.windows.net/<tenant-name>/reports/SignInsAfterMultipleFailuresEvent?api-version=beta

 

Context for requests on their blog here:

https://msdn.microsoft.com/en-us/Library/Azure/Ad/Graph/howto/azure-ad-reports-and-events-preview#overview-and-prerequisites

 

3 Replies

    • RobFlanders's avatar
      RobFlanders
      Frequent Visitor

      If I can call other elements of the API through a standard web-query I would imagine it is supported? Is there something about the reports queries that cannot be queried?

  • Satish87's avatar
    Satish87
    Regular Visitor

    is it still not supported ? I need to get sign in event from Azure AD in Power BI desktop.