How do I display GEOLOCATION of devices using their sign-in from Azure Active Directory ?

[Anonymous]

I'm trying to display the GEOLOCATION of devices using their sign-in from Azure Active Directory ? I perform the following steps:

Get Data > More > Active Directory > Connect > Enter domain > select from tree the domain > select most of the fields.  HOWEVER, I'm not sure I'm doing this correctly.  My selections for Get Data, Azure Active Directory is not an option, just Active Directory.  I'm also currently connected to Intune Data Warehouse, but the "sign-ins" come from AAD (I believe).  So the goal is to visually dispaly to geolocation of the device after the user signs in to their device.

[Anonymous]

Does anyone have a solution to my issue ?  I need to display GEOLOCATION of devices; where they sign-in from.  It is displayed in Intune for Windows/iOS/Android devices we manage.  I access the Intune Data Warehouse.  Most docs out there on Google are not providing instructions on how to access and display that info.  I have PBI Version: 2.100.1182.0 64-bit (December 2021).

[truptis]

Hi @Anonymous ,

I hope you have Azure AD Premium & Power BI license assigned.
Follow the below steps:

- Firstly, we need to sign in into Power BI and pull in the Azure AD Activity Logs Content Pack.
you can do this in Power BI by selecting Get Data-> Services (Get)-> then search for Azure -> Select Azure Active Directory Activity Logs (Preview) from the search results

- then provide your Azure AD domain name -> select next

- Once the Azure Active Directory Activity Logs (Preview) content is added we can begin to create a dashboard
- From the Power BI UI find the “Azure Active Directory Activity Logs” under Dataset and select it
- In “Visualizations” pane, select Map
- In “Fields” pane-> expand “Signin Activity” ->select the City, Country, Name, and Total Signins
@Anonymous -> Please hit the thumbs up & mark it as a solution if it helps you. Thanks.

[Anonymous]

truptis,  I have Azure AD Premium and PBI license.  Is this response from the following article? https://uem4all.com/2017/03/28/azure-ad-geolocation-by-sign-in-activity-using-power-bi/

I wouldn’t follow that article too closely, it was published in 2017 for a dataset connector that was in preview and has since been deprecated.