Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature Request: Add Analysis Services Support #1026

Open
demyte opened this Issue Mar 28, 2018 · 10 comments

Comments

Projects
None yet
@demyte
Copy link

commented Mar 28, 2018

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

This comment has been minimized.

Copy link

commented Nov 7, 2018

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

This comment has been minimized.

Copy link

commented Nov 8, 2018

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

This comment has been minimized.

Copy link

commented Nov 8, 2018

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

This comment has been minimized.

Copy link

commented Nov 8, 2018

It would also help with the cross platform goals

@otykier

This comment has been minimized.

Copy link

commented Nov 9, 2018

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

This comment has been minimized.

Copy link

commented Dec 2, 2018

yes, we all want this!

@erapade

This comment has been minimized.

Copy link

commented Dec 2, 2018

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

@affsantos

This comment has been minimized.

Copy link

commented Dec 4, 2018

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

@yualan yualan added Enhancement and removed suggestion labels Dec 7, 2018

@PietkaSmig

This comment has been minimized.

Copy link

commented Jan 12, 2019

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 .

@AlejoSQL

This comment has been minimized.

Copy link

commented Mar 12, 2019

Absolutely! @vickyharp , this goes in line with the conversations about modernizing the experience for more traditional DB / no data science people. Support for MDX, DAX, TMSL and M would be a massive win!!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.