PowerBI Integration about metriql HOT 5 OPEN

Given that MDX and DAX are widely adopted in the MS ecosystem, we can just throw a parser them and convert them to Segmentation queries if possible. olap4j doesn't seem to be maintained but it seems to be the only alternative, I will check olap4j and see if I can get it working.

The XMLA server will implement the following endpoints:
https://docs.microsoft.com/en-us/analysis-services/xmla/xml-elements-methods-discover?view=asallproducts-allversions
https://docs.microsoft.com/en-us/analysis-services/xmla/xml-elements-methods-execute?view=asallproducts-allversions

Samples:
https://github.com/pentaho/mondrian/blob/d94651d21bc6f4047d297c0ebe91b0eda43b2bbd/mondrian/src/main/java/mondrian/tui/XmlaSupport.java
https://github.com/pentaho/mondrian/blob/d94651d21bc6f4047d297c0ebe91b0eda43b2bbd/mondrian/src/main/java/mondrian/xmla/impl/DefaultXmlaServlet.java
https://github.com/pentaho/mondrian/tree/d94651d21bc6f4047d297c0ebe91b0eda43b2bbd/mondrian/src/main/java/mondrian/xmla/impl

API:
https://docs.microsoft.com/en-us/analysis-services/xmla/xml-for-analysis-xmla-reference?view=power-bi-premium-current&preserve-view=true
DAX Parser: https://github.com/microsoft/powerquery-parser
MDX for Java: https://github.com/olap4j/olap4j and https://github.com/olap4j/olap4j-xmlaserver
MDX Grammer: https://github.com/antlr/grammars-v4/blob/master/mdx/mdx.g4

from metriql.

Once we build the XMLA server, we will parse MDX queries and generate Segmentation Query and generate the SQL for the underlying database. I'm dropping a SO question that can help us understand the language:

https://stackoverflow.com/questions/56788153/convert-mdx-to-sql-statement

Edit: Later I figured out that it's not that easy to build an MDX parser as it's a full language similar to SQL. See the current approach below.

from metriql.

Here is an alternative method: trinodb/trino#6886
If we use TOM in addition to ODBC, it should also work: https://www.powerbidevcamp.net/articles/programming-datasets-with-TOM/

Also see: openlookeng/hetu-odbc-driver#1
https://dax.tips/2020/07/30/automatically-create-measures-in-power-bi-using-vs-code/

https://github.com/olap4j/olap4j and https://github.com/olap4j/olap4j-server

from metriql.

Please see the relevant discussion if you're interested in being an early adopter! 🙏 #22

from metriql.

Any news on how we can best use metricql with PBI?

from metriql.