SharePoint Online: PowerShell to Get All User Profiles

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.UserProfiles.dll"
 
#Variables
$AdminSiteUrl = "https://crescent-admin.sharepoint.com"
$CSVPath = "C:\Temp\UserProfiles.csv"

#Get Credentials
$Cred = Get-Credential

#Connect to AzureAD
Connect-AzureAD -Credential $Cred

#Get All Users from AzureAD
$AllUsers = Get-AzureADUser -All:$True
Write-host "Total Number of User Profiles Found:"$AllUsers.Count

#Setup the context
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($AdminSiteURL)
$Ctx.Credentials = $Credentials

#Collect User data
$PeopleManager = New-Object Microsoft.SharePoint.Client.UserProfiles.PeopleManager($Ctx)
$UserDataCollection = @()

$Counter = 1
ForEach($User in $AllUsers)
{
    #Get User Profile
    $UserProfile = $PeopleManager.GetPropertiesFor(('i:0#.f|membership|'+$User.UserPrincipalName))
    $Ctx.Load($UserProfile)
    $Ctx.ExecuteQuery()

    Write-Progress -Activity "Extracting User Profile Data..." -Status "Getting User Profile $Counter of $($AllUsers.Count)" -PercentComplete (($Counter / $AllUsers.Count)  * 100)
    #Get User Profile Data
    $UserData = New-Object PSObject
    ForEach($Key in $UserProfile.UserProfileProperties.Keys)
    {   
        $UserData | Add-Member NoteProperty $Key($UserProfile.UserProfileProperties[$Key])
    }
    $UserDataCollection += $UserData
    $Counter++
}

#Export Data to CSV File
$UserDataCollection | Export-Csv -Path $CSVPath -NoTypeInformation

#Config Variables
$AdminSiteURL = "https://crescent-admin.sharepoint.com"
$SPOPropertyName = "Office"
$CSVPath = "C:\Temp\UserProfileProperty.csv"

Try {
    #Connect to AzureAD
    Connect-AzureAD
 
    #Get All Users of the Domain from AzureAD
    $AllUsers = Get-AzureADUser -All:$True -Filter "UserType eq 'Member'"
    Write-host "Total Number of User Profiles Found:"$AllUsers.Count 
 
    #Connect to PnP Online
    Connect-PnPOnline -Url $AdminSiteURL -Interactive
 
    #Iterate through All Users
    $Counter = 1
    $UserProfileData = @()
    ForEach($User in $AllUsers)
    {
        Write-host "`nGetting User Profile Property for: $($User.UserPrincipalName)" -f Yellow
 
        #Get the User Property value from SharePoint   
        $UserProfile = Get-PnPUserProfileProperty -Account ($User.UserPrincipalName)
 
        #Collect the data
        $UserProfileData += New-Object PSObject -Property @{
            'User Account' = $UserProfile.UserProfileProperties["UserName"]
            'Location' = $UserProfile.UserProfileProperties[$SPOPropertyName]
        }

        $Counter++
        Write-Progress -Activity "Getting User Profile Data..." -Status "Getting User Profile $Counter of $($AllUsers.Count)" -PercentComplete (($Counter / $AllUsers.Count)  * 100)
    }
    #Export the data to CSV
     $UserProfileData | Export-Csv $CSVPath -NoTypeInformation
 
     write-host -f Green "User Profiles Data Exported Successfully to:" $CSVPath
}
Catch {
    write-host -f Red "Error Getting User Profile Property!" $_.Exception.Message
}