Powerhell Notebooks in ADS–A Minor Issue

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!

2019-11-05 15_32_11-● PoShNotebookTest.ipynb - Azure Data Studio

I selected this dropdown and saw this:

2019-11-05 15_05_22-● Notebook-0 - Azure Data Studio

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.

2019-11-05 15_33_37-cmd

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.

2019-11-05 15_36_15-● PoShNotebookTest.ipynb - Azure Data Studio

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.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , . Bookmark the permalink.

1 Response to Powerhell Notebooks in ADS–A Minor Issue

  1. way0utwest says:

    This is for powershell though. There isn’t good verbiage that explains why or that python is needed to activate posh.

    I do have python 3.x installed as well. Not sure why this wasn’t picked up or if the version is old but it’s a strange and poor design of the ux

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.