pacakages to connect to ssas from databricks

Ullas Mulbagal Sripathi Rao 46 Reputation points
2021-11-19T11:06:45.78+00:00

hi , I am trying to connect to ssas cube from data bricks and run dax . we have an external application for which we have to provide an api to connect to ssas cube.
we are trying to build an application which can connect to ssas cube from python on azure data bricks.
are there any packages available?

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,853 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,234 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MartinJaffer-MSFT 25,991 Reputation points
    2021-11-19T22:47:30.443+00:00

    Hello @Ullas Mulbagal Sripathi Rao and welcome to Microsoft Q&A.

    Most of the libraries I have found are rooted in .NET.
    I have found some related threads suggesting pyadmomd , also some difficulties with it.
    Another method adds dll instead of python package (Stack Overflow link).

    Excerpt from analysis-services-developer-documentation

    Although it is possible to build a solution based on the open standards of XMLA and MDX, it's quite rare to do so. There is no documentation other than XMLA and MDX reference to help you, and most community and forum support draws from experiences with .NET or native (MSOLAP) technologies.


  2. Ullas Mulbagal Sripathi Rao 46 Reputation points
    2021-11-23T10:16:42.6+00:00

    kindly let me know if there is a code snippet in dotnet which connects to SSAS cube. this will help us implement it.
    the pyadmomd doesnt seem to work to connect with .net .