Forum Discussion
Reporting on user attributes in Azure Active Directory
Dear All,
I am trying to build dashboards on Intune device management usage. I am using the Odata feed made available in Intune itself in the Datawarehouse options. Works fine (data is not realtime but has up to 24 hours delay). One information I am missing is the user location. Currently only userid/email fields are available.
Country attribute can be found in Azure Active Directory and correlated using userid but so far I have not been able to query it form PowerBI. I 've tried building a logic app and access it using a Web data source but being thousands of users I run into paging issues/time outs etc. I trimmed it down to UserID, UserPrincipalName, DisplayName, Country but still unstable/unusable.
Has anybody been successfull in running such a report on Azure Active Directory? Seems strange to me that such an operations commonly availble using Graph or Powershell cmdlets is turning out to be very cumbersome (at least to me).
My eternal gratitude to anyone who may be able to assist.
Cheers,
KM
2 Replies
- amitchandak
Super User
KarlMarx , refer if this can help - https://www.biinsight.com/power-bi-and-active-directory-for-system-administrators/
Thank you amitchandak
Unfortunately this data source connector you mention does not support Azure AD but only Active Directory on prem. On top of that, the attribute uniquely identifying the user (object id field ) is generated in Azure Active Directory and does not exist in local AD (we sync our local Active Directory to Azure Active Directory where that attribute is added and used to link other objects in the Azure ecosystem consuming the cloud identity ).
