GitHub user dosubot[bot] added a comment to the discussion: Does Superset support connecting to SSAS (SQL Server Analysis Services) MDX/DAX cubes?
<!-- Answer --> Apache Superset does not natively support connecting to Microsoft SSAS (SQL Server Analysis Services) cubes or running MDX/DAX queries. Superset generally requires a SQL interface and does not support MDX, which is the primary query language for SSAS cubes, as confirmed by maintainers and community discussions [(source)](https://github.com/apache/superset/issues/31990). There is no official plugin or third-party connector for SSAS. However, there is an ongoing community effort to add SSAS support by developing a custom SQLAlchemy dialect and engine spec. This approach is not yet stable or officially supported, and users attempting it have encountered integration challenges and errors [(source)](https://github.com/apache/superset/discussions/33093). Some users explore workarounds like using intermediary engines (e.g., Trino or Apache Drill) that Superset can connect to, but there is no documented or confirmed solution for SSAS cubes specifically [(source)](https://github.com/apache/superset/discussions/33747). In summary: direct, out-of-the-box support for SSAS and MDX/DAX queries is not available in Superset. Community-driven custom development is in progress, but there is no turnkey solution yet. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/e4ad7499-e142-4bd2-b167-caa64669f0d5?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/e4ad7499-e142-4bd2-b167-caa64669f0d5?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/e4ad7499-e142-4bd2-b167-caa64669f0d5?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/e4ad7499-e142-4bd2-b167-caa64669f0d5?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e4ad7499-e142-4bd2-b167-caa64669f0d5?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/e4ad7499-e142-4bd2-b167-caa64669f0d5?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e4ad7499-e142-4bd2-b167-caa64669f0d5?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=Apache%20Superset%20does%20not%20natively%20support%20connecting%20to%20Microsoft%20SSAS%20%28SQL%20Server%20Analysis%20Services%29%20cubes%20or%20running%20MDX/DAX%20queries.%20Superset%20generally%20requires%20a%20SQL%20interface%20and%20does%20not%20support%20MDX%2C%20which%20is%20the%20primary%20query%20language%20for%20SSAS%20cubes%2C%20as%20confirmed%20by%20maintainers%20and%20community%20discussions%20%5B%28source%29%5D%28https%3A//github.com/apache/superset/issues/31990%29.%0A%0AThere%20is%20no%20official%20plugin%20or%20third-party%20connector%20for%20SSAS.%20However%2C%20there%20is%20an%20ongoing%20community%20effort%20to%20add%20SSAS%20support%20by%20developing%20a%20custom%20SQLAlchemy%20dialect%20and%20engine%20spec.%20This%20approach%20i s%20not%20yet%20stable%20or%20officially%20supported%2C%20and%20users%20attempting%20it%20have%20encountered%20integration%20challenges%20and%20errors%20%5B%28source%29%5D%28https%3A//github.com/apache/superset/discussions/33093%29.%0A%0ASome%20users%20explore%20workarounds%20like%20using%20intermediary%20engines%20%28e.g.%2C%20Trino%20or%20Apache%20Drill%29%20that%20Superset%20can%20connect%20to%2C%20but%20there%20is%20no%20documented%20or%20confirmed%20solution%20for%20SSAS%20cubes%20specifically%20%5B%28source%29%5D%28https%3A//github.com/apache/superset/discussions/33747%29.%0A%0AIn%20summary%3A%20direct%2C%20out-of-the-box%20support%20for%20SSAS%20and%20MDX/DAX%20queries%20is%20not%20available%20in%20Superset.%20Community-driven%20custom%20development%20is%20in%20progress%2C%20but%20there%20is%20no%20turnkey%20solution%20yet.) [](https://go.dosu.dev/discord-bot) [![Share on X] (https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/36356) GitHub link: https://github.com/apache/superset/discussions/36356#discussioncomment-15123932 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
