Unable to load Az modules - Assembly with same name is already loaded

Prerequisites

• I have written a descriptive issue title.
• I have searched all open and closed issues to ensure it has not already been reported.
• I have read the troubleshooting guide.
• I am sure this issue is with the extension itself and does not reproduce in a standalone PowerShell instance.
• I have verified that I am using the latest version of Visual Studio Code and the PowerShell extension.
• If this is a security issue, I have read the security issue reporting guidance.

Summary

If you load a PowerShell file that has references to Azure PowerShell commands the assemblies are being loaded without loading the module fully.

This is repeat of #3012 which was closed with no solution. Extensions do not matter in this case, it is when a file that has Azure module references is opened the assemblies get loaded but not the actual modules.

PowerShell Version

> $PSVersionTable

Name                           Value
----                           -----
PSVersion                      7.2.13
PSEdition                      Core
GitCommitId                    7.2.13
OS                             Darwin 21.6.0 Darwin Kernel Version 21.6.0: Thu Jul  6 22:20:00 PDT 2023; root:xnu-8020.240.18.702.13~1/RELEASE_A…
Platform                       Unix
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

Visual Studio Code Version

> code-insiders --version 
1.82.0-insider
f1302be1e67e3af5fbeb8bbb2ea784de7bc96150
arm64

Extension Version

> code --list-extensions --show-versions | Select-String powershell

ms-vscode.powershell@2023.6.0

Steps to Reproduce

1. Close all PowerShell files
2. Restart session for PowerShell Extension
3. Run following command to list loaded assemblies

[System.AppDomain]::CurrentDomain.GetAssemblies() | Where-Object Location | Sort-Object -Property FullName | Select-Object -Property FullName, Location, GlobalAssemblyCache, IsFullyTrusted | Where FullName -like '*azure*' | ft

4. Note nothing is returned
5. Run Get-Module Az*
6. Nothing is returned
7. Open file (any file) with Az PowerShell references
8. Rerun step 3
9. All assemblies for the Az.Accounts and related commands are loaded
10. Rerun step 5
11. Nothing is returned
12. Run Import-Module Az.Accounts
13. Error returned: Import-Module: Assembly with same name is already loaded

Visuals

https://github.com/PowerShell/vscode-powershell/assets/11204251/113bb121-5cd8-482d-847b-184bb594cb84

Logs

ext_logs.zip

Start by reproducing the sequence in the PowerShell extension: open a file with Az references, inspect loaded assemblies with the provided AppDomain command, then run Get-Module Az* and Import-Module Az.Accounts. Use the attached extension logs and the extension's assembly-loading path to determine why assemblies load without the module; done means Az.Accounts imports successfully after opening the file.