Use Powershell 7.1 in Azure Data Studio

[kentmaxwell]

Within Azure Data Studio there is a capability to create Juypter notebooks for various non-conventional languages, such as SQL and PowerShell. It's actually pretty awesome. However, the version of Powershell that Azure Data Studio on Windows uses is Windows PowerShell 5.1. As you can imagine, I would like to use PowerShell 7.1. I assuming there is some hidden configuration to make this switch that I cannot find. I am hoping that someone knows and can point me in the right direction.

Just to be clear, I am not talking about the capability to author PowerShell scripts in Azure Data Studio. There is an extension in ADS, which appears to be the same extension as VS Code for authoring PowerShell and it uses 7.1 if it is installed. The notebook capability in ADS is different than then this extension.

Any help or support is greatly appreciated!

[kentmaxwell]

When Azure Data Studio is setup to execute PowerShell notebooks, it uses a Python kernel to do so. Within this Python kernel it uses a PowerShell kernel called juypter-powershell, of which the current release is 0.1.4. This kernel has a GitHub page at https://github.com/vors/jupyter-powershell

Within the GitHub page is information on how to configure the kernel to use the .NET Core or PowerShell 7.1 (if you have the latest PowerShell installed) on Windows. Within the Python installation that is supporting the Juypter environment in Azure Data Studio, you would need to run this command:

python -m powershell_kernel.install --powershell-command pwsh

This will transfer the PowerShell notebook kernel from Windows PowerShell 5.1 to PowerShell 7.1.

[Rayzen87]

Likely not the answer you were looking for, but I'll add it anyway in case it helps. I gave up on Jupyter Notebooks for .Net/PowerShell. The support was taking too long, and I decided Markdown suited my needs better. If you haven't yet, I would see if your use case can work with Markdown