Feature Request: Add Analysis Services Support

[demyte]

It would be great to be able to connect to Analysis Services instances (both multi-dimensional and tabular) and run MDX, DAX and XMLA queries.

[cwebbbi]

I absolutely want Analysis Services support too. I would love full support for all flavours of Analysis Services but in practical terms I would be happy with support for just Analysis Services Tabular 2016+ and Azure Analysis Services, and eventually Power BI Premium via XMLA endpoints (which should be available in 2019). For language support, as well as DAX I would also want M and TMSL too; MDX would be nice but is less of a priority. I would also like the ability to connect to Analysis Services xEvents.

[PaulTinNZ]

Second all that's been said and particularly connect to Analysis Services xEvents.
Would also think that the SQL Server Analysis support team at MS must have plenty of tools that would enhance our management and vision into the application.
Like showing which session is using all the available server memory...just one quick example.

[JanMulkens]

I'd love everything that's on Chris' wishlist! 🙂

https://blog.crossjoin.co.uk/2018/11/08/azure-data-studio-analysis-services-power-bi/

[matt40k]

It would also help with the cross platform goals

[otykier]

Yes! I believe a prerequisite for this, would be to compile the AMO/TOM library against .NET Standard, right? That would also be of great value to the community - imagine, for example, a cross-platform version of Tabular Editor.

[grosr]

yes, we all want this!

[erapade]

Agree. Would like to be able to write DAX queries kind of the same way (using the MDX mode) as in SSMS

[affsantos]

Please Microsoft, do this! Multidimensional and Tabular on-prem :)

[PietkaSmig]

Hi, what do you think when can you start working on this ? Basically the soft is pretty cool, works very fast and looks nice however any BI developer in an average size company is using SSAS and SQL. You prepare data in sql and prepare tabular model - the amount of data always put into this direction. Adding MySQL would be also a very good move. At least you could start from ODBC drivers and get closer to functionality available in MS Excel .