Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI d… ...

…even though the subtotals in the PivotTable are not displayed in Excel, the MDX query generated by Excel not only returns them but also returns others that are not needed at all – in fact 36 rows ...

Any PivotTable connected to Microsoft SQL Server Analysis Services, third party OLAP providers or the Power Pivot Data Model will likely give you fresh data, faster. Additionally, now if you disable ...

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.