We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Connection to SQL Server Analysis Services

Desperately looking for a way to connect to SQL Server Analysis Services through Alteryx as more and more of our large datasets from our older systems are moving to here in the next few months. We can connect using PowerBi with limitations (connecting 'Live' does not allow merge and connecting with Import, you need to use MDX or DAX syntax). We run into import and export limitations, too. We are not allowed access to the underlying tables, but the tables with the measures, dimensions and fields. PowerBi is a big step up from pivot tables, but Alteryx would be so much better. Ideas for connecting this up are are welcome!

 

7 Comments
AhmedAlZabidi
7 - Meteor

Also, I want to connect to SQL Server Analysis through Alteryx. Is there any update?

KPost
7 - Meteor

Also inquiring about the SSAS connection.

JohnSt
Alteryx Alumni (Retired)

A lot of Alteryx customers us SQL Server as the data repository for data from legacy systems.  Basically they copy the data from legacy into SQL Server with little or no changes to the data.  Then they use SSAS to gather they data for reporting.  Most of the time our Alteryx Designer users do not have access to the SQL Server source tables and only can access the SSAS Tabular tables, which is not the same as RDMS tables

neveuge
5 - Atom

Hi,

 

In this case, in roder to connect ourself to the SSAS Tabular tables what kind of connectors do we need to use in Alteryx ?

 

Thanks,

mathieuf
Alteryx
Alteryx

Hi all,

 

This topic is a bit old but have you looked at the SSAS Connector from Casabase Software on the Public Gallery: https://gallery.alteryx.com/#!app/SSAS-Connector/5da5b2e8826fd3112c85d012

 

Hope this help to solve your challenges!

Robbobu1
7 - Meteor

Is there a solution for SSAS connections in Alteryx that does not require another third party add on?  As noted above, we have access to the SSAS data models but not the underlying sql.  This would be a fantastic add.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes