Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NewUser777
Resolver I
Resolver I

Why a tabular model defined in DAX can be queried using MDX?

I understand if the model is  tabular model then you have to use DAX  to define the business logic \calculations but why a tabular model can be queried using MDX ? What are the use cases?

 

 

1 ACCEPTED SOLUTION
Ghhousuddin
Resolver I
Resolver I

A tabular model defined in DAX can be queried using MDX because Microsoft has added support for the Multidimensional Expressions (MDX) language in Analysis Services Tabular mode starting with SQL Server 2012. This was done to allow existing MDX-based client tools, such as Excel PivotTables, to connect to and query a Tabular model.

There are several use cases for querying a Tabular model using MDX:

1. Compatibility with existing client tools: As mentioned above, some client tools, such as Excel PivotTables, are designed to work with MDX and may not support DAX. By providing support for MDX in Tabular mode, Microsoft allows these tools to work with Tabular models.

2. Cross-compatibility with other data sources: MDX is a widely used language for querying multidimensional data sources, such as OLAP cubes. By providing support for MDX in Tabular mode, Microsoft allows Tabular models to be queried using the same language as other data sources, which can simplify integration and interoperability.

3. Advanced calculations: While DAX is a powerful language for defining calculations in a Tabular model, MDX provides more advanced functionality for complex calculations and analysis. In some cases, it may be more efficient or easier to define a calculation using MDX rather than DAX.

4. Backward compatibility: Some organizations may have existing MDX-based reports or queries that need to be migrated to a Tabular model. By providing support for MDX in Tabular mode, Microsoft makes it possible to migrate these queries without having to rewrite them in DAX.

In summary, while DAX is the primary language for defining calculations in a Tabular model, MDX provides compatibility with existing client tools, cross-compatibility with other data sources, advanced calculations, and backward compatibility with existing queries.

View solution in original post

1 REPLY 1
Ghhousuddin
Resolver I
Resolver I

A tabular model defined in DAX can be queried using MDX because Microsoft has added support for the Multidimensional Expressions (MDX) language in Analysis Services Tabular mode starting with SQL Server 2012. This was done to allow existing MDX-based client tools, such as Excel PivotTables, to connect to and query a Tabular model.

There are several use cases for querying a Tabular model using MDX:

1. Compatibility with existing client tools: As mentioned above, some client tools, such as Excel PivotTables, are designed to work with MDX and may not support DAX. By providing support for MDX in Tabular mode, Microsoft allows these tools to work with Tabular models.

2. Cross-compatibility with other data sources: MDX is a widely used language for querying multidimensional data sources, such as OLAP cubes. By providing support for MDX in Tabular mode, Microsoft allows Tabular models to be queried using the same language as other data sources, which can simplify integration and interoperability.

3. Advanced calculations: While DAX is a powerful language for defining calculations in a Tabular model, MDX provides more advanced functionality for complex calculations and analysis. In some cases, it may be more efficient or easier to define a calculation using MDX rather than DAX.

4. Backward compatibility: Some organizations may have existing MDX-based reports or queries that need to be migrated to a Tabular model. By providing support for MDX in Tabular mode, Microsoft makes it possible to migrate these queries without having to rewrite them in DAX.

In summary, while DAX is the primary language for defining calculations in a Tabular model, MDX provides compatibility with existing client tools, cross-compatibility with other data sources, advanced calculations, and backward compatibility with existing queries.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.