Azure AD Reports API

[RobFlanders]

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#ov...

[Satish87]

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

[v-chuncz-msft]

@RobFlanders,

It seems not supported. You may also try Custom Data Connectors.

[RobFlanders]

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?