SharePoint Online: Get Subsite Size using PowerShell

#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"
 
#Function to Get the size of a Folder in SharePoint Online
Function Get-SPOFolderSize([Microsoft.SharePoint.Client.Folder]$Folder)
{ 
     Try
     {
        Write-host -f Yellow "Size of the Folder '$($Folder.ServerRelativeUrl)' : " -NoNewline
        
        $FolderSize = 0
        #Get all Files and Subfolders from the folder
        $Ctx.Load($Folder.Files)
        $Ctx.Load($Folder.Folders)
        $Ctx.ExecuteQuery()

        ForEach($File in $Folder.Files)
        {
            #Get File Size
            $FolderSize += $File.Length
        }
        Write-host $FolderSize

        #Process all Sub Folders
        ForEach($Folder in $Folder.Folders)
        {
            #Call the function recursively
            $FolderSize +=Get-SPOFolderSize $Folder
        }
        Return $FolderSize
    }
    Catch [System.Exception]
    {
        Write-Host -f Red "Error:"$_.Exception.Message
    }
}
 
#parameters
$SiteURL = "https://Crescent.sharepoint.com/unitedstates"
 
#Get credentials to connect to SharePoint Online Admin Center
$Cred = Get-Credential
 
#Set up the context
$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
   
#Get the Web
$Web = $Ctx.Web
$RootFolder = $Web.RootFolder
$Ctx.Load($RootFolder)
$Ctx.ExecuteQuery()

#Call the function to get Subsite size
$SubSiteSize = Get-SPOFolderSize -Folder $RootFolder

#sharepoint online powershell site size
Write-host "Toal Size of the subsite (MB): " -NoNewline
[Math]::Round($SubSiteSize/1MB, 2)

#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"
 
#Function to Get the size of a Folder in SharePoint Online
Function Get-SPOFolderSize([Microsoft.SharePoint.Client.Folder]$Folder)
{ 
     Try
     {
        Write-host -f Cyan "`t Size of the Folder '$($Folder.ServerRelativeUrl)' : " -NoNewline
        
        $FolderSize = 0
        #Get all Files and Subfolders from the folder
        $Ctx.Load($Folder.Files)
        $Ctx.Load($Folder.Folders)
        $Ctx.ExecuteQuery()

        ForEach($File in $Folder.Files)
        {
            #Get File Size
            $FolderSize += $File.Length
        }
        Write-host $FolderSize

        #Process all Sub Folders
        Foreach($Folder in $Folder.Folders)
        {
            #Call the function recursively
            $FolderSize +=Get-SPOFolderSize $Folder
        }
        Return $FolderSize
    }
    Catch [System.Exception]
    {
        Write-Host -f Red "Error:"$_.Exception.Message
    }
}

Function Get-SPOSubsiteSize([Microsoft.SharePoint.Client.Web]$Web)
{  
    Write-host -f Yellow "Finding the Size of the subsite:"$web.Url 
    $StorageMetrics= @()

    #Get the Root Folder of the Web
    $Ctx = $Web.Context
    $RootFolder = $Web.RootFolder
    $Ctx.Load($RootFolder)
    $Ctx.Load($Web.Webs)
    $Ctx.ExecuteQuery()

    #Call the function to get Subsite size
    $SubSiteSize = Get-SPOFolderSize -Folder $RootFolder
    $SizeinMB = [Math]::Round($SubSiteSize/1MB, 2)
    Write-host -f Green "Toal Size of the subsite (MB): $SizeinMB `n"
    
    #Add the result to an Array
    $StorageData = New-Object PSObject
    $StorageData | Add-Member NoteProperty SiteURL($web.Url)
    $StorageData | Add-Member NoteProperty Size-MB([math]::Round($SubSiteSize/1MB,2))
    $StorageMetrics += $StorageData

    #Process all subsites
    ForEach($Subweb in $web.Webs)
    {         
        $StorageMetrics+=Get-SPOSubsiteSize $Subweb
    }
    Return $StorageMetrics
}

#parameters
$SiteURL = "https://Crescent.sharepoint.com"
$CSVPath="C:\Temp\SubsiteStorage.csv"

#Delete the Output Report, if exists
If (Test-Path $CSVPath) { Remove-Item $CSVPath }

#Get credentials to connect to SharePoint Online Admin Center
$Cred = Get-Credential
 
#Set up the context
$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
   
#Get the Root Web
$Web = $Ctx.Web
$Ctx.Load($Web)
$Ctx.ExecuteQuery()

#Call the function to get subsite storage metrics
$SubsiteStorageMetrics = Get-SPOSubsiteSize $Web

#Export the results to CSV
$SubsiteStorageMetrics | Export-CSV -LiteralPath $CSVPath -NoTypeInformation