Any possible SSAS extension or equivalent in VS Studio Code

[smpa01]

TLDR: Does there exist an extension for VS Studio Code that enables users to query a ssas db the same way (mssql for sql server) / (Dax Studio / SSMS for ssas) enables?

Is there any way for me to connect to a SSAS server (e.g. workspace) and db Tables from any VS Studio Code (not VS Studio) extension and run queries (basically replicate what SSMS/DAX Studio is capable of doing).

I frequently use mssqlExtension but it can't connect to an ssas server (will be exteremly happy to be proved wrong). If it  or any other extsnion can, it will be awesome. I want to stay in VS Studio code environement while querying so that I can simultaneously work with backend (SSAS) and frontend (webpack) without needing to switch between diffrent environments. Also, it makes creating documentation pretty easy within a single environment.

Any pointers will be awesome !!!

@dm-p @AlexisOlson @bcdobbs @d_gosbell @parry2k 

[smpa01 · Accepted solution]

Thanks to  @gbrueckl I managed to the above using PowerBI-VSCode  .

This is simply awesome !!!

[v-zhouwen-msft]

Hi @smpa01 ,

I'm glad you solved the problem, and you might consider marking your approach as a solution so that more people can see it!