I heard about the addition of PoSh as a kernel for notebooks in Azure Data Studio. This is in the November 2019 release, and you can download/upgrade today to get the feature. I started ADS, let it download the update, and then ran the install.
As soon as ADS installed, I created a new notebook, and added a code cell. I saw Powershell in the kernel dropdown. Sweet!
I selected this dropdown and saw this:
Hmmm, maybe I picked the wrong one. I tried this again and got the same result. I checked, and I have Python installed, but apparently not a version compatible with ADS.
I restarted ADS. Same thing.
I restarted my computer; same thing. I saved the notebook, added other cells, did a few things and got the same result.
At this point, I suspected that the developers of ADS had all installed Python as part of their core image for ADS. So I clicked “install Python”. Once this completed, which took awhile. Once this was complete, and the kernels reloaded, PowerShell notebooks work.
Aaron Nelson published a post about this, with more details on how to get the kernel working. To me, this is a bug, as the message should tell me Python is needed for the PoSh kernel.