Analysis Services Tabular improves MDX query performance in the cloud
With a recent update of the Analysis Services Tabular engine in Azure Analysis Services (AAS) and in Power BI, Multidimensional Expressions (MDX) clients, such as Microsoft Excel, can now enjoy improved query performance. This MDX performance improvement alleviates some of the optimization burden for measures used in a PivotTable.
Source: Azure Roadmap