Announcing improved MDX query performance in Power BI
With a recent update of the Analysis Services Tabular engine 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. For example, Excel users connecting to a Power BI dataset by using the Analyze in Excel feature, the XMLA endpoint, or the newly announced Power BI Datasets within Excel feature, will now notice significantly better PivotTable performance out of the box.