ForEachObject -Parallel with Get-PnpFile

[ghost]

I have a script that downloads files from SharePoint and manipulates the downloaded files in Excel. I’d like to run it asynchronously with ForEach-Object -Parallel so I can manipulate multiple files simultaneously, but I’m running into issues with Get-PnPFile.

The code below works if the $Reports array contains one value. But when there’s multiple values, I receive the error Object reference not set to an instance of an object. from the Get-PnpFile cmdlet.

Can anyone shed some light on the cause of this error?

$TempDir = [System.IO.Path]::GetTempPath()
$Reports = @(
    @{
        URL = 'https://myurl.sharepoint.com/sites/MySite'
        RelativeFileURL = '/sites/MySite/Shared Documents/File001.xlsx'
        TempFile = 'temp001.xlsx'
    },
    @{
        URL = 'https://myurl.sharepoint.com/sites/MySite'
        RelativeFileURL = '/sites/MySite/Shared Documents/File002.xlsx'
        TempFile = 'temp002.xlsx'
    }
)
$SPOCredentials = Get-Credential
 
$Reports | ForEach-Object -Parallel {
    $URL = $_['URL']
    $RelativeFileURL = $_['RelativeFileURL']
    $TempFileName = $_['TempFile']
    $Connection = Connect-PnPOnline -URL $URL -Credentials $using:SPOCredentials -ReturnConnection
    Get-PnPFile -Url $RelativeFileURL -Path $using:TempDir -Filename $TempFileName -Connection $Connection -AsFile -Force
    Disconnect-PnPOnline -Connection $Connection
}