Bundle of Notebooks for Microsoft Azure Data Studio
Use %%lang_r or %%lang_py to switch the languages without switching the kernels. You should install the Machine Learning extension and set the R or Pyhon path to preinstalled environments.
Install the Machine Learning extention

Next you need to navigate to settings and find the same extention:

And type in the correct path to the language

Once setting up the path is completed, you can start using the lang_py or lang_r function.

And you should be fine.